filtering colums

B

benny

Can anyone tell me how I filter a column, so it shows the entries that are
not present in a second column? say:
column1: column2:
1 2
2 5
3
4
5
How can I get a third column showing:
1
3
4

Is this possible in Excel???

Thx..
 
D

Dave Peterson

Can you use a third column and filter on that?

I'd put this in C2 (headers in Row 1):

=isnumber(match(a2,b:b,0))
and copy down

Then filter to show the False's in that column.
 
B

benny

Thx, ur post lead me onto something I could use. Im having a danish version
of excel, and Im not sure about the english equivalent of my spreadsheet
functions. But my danish funtion looks like:
=HVIS(ER.FEJL(SAMMENLIGN(A2;$B$2:$B$16;0));A2)

where SAMMENLIGN=match
ER.FEJL ~ IsError
HVIS ~ IF

Thx again for responding to my problem :)
 
Top