to filter out those that are not in B, how would I do it? Is there a
way?
i.e.
Column A Column B
123 12345
12345 123
123123
I want “123123” to show up in Column C or something — I want to know
the numbers that are not showing in both.
[Excel 97]
Assuming that you have filled 30 rows in columns A and B (->range
A2:B31).
In C2, enter :
=IF(COUNTIF(B$2:B$31,A2),””,A2)
and copy down.
After this, you can apply a filter on column C (show only the not empty
cells).]]>