filtering colums

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

benny - 25 Jan 2006 17:21 GMT

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..

Reply to this Message

Dave Peterson - 25 Jan 2006 17:33 GMT

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.

> Can anyone tell me how I filter a column, so it shows the entries that are
> not present in a second column? say:
[quoted text clipped - 12 lines]
>
> Thx..

Signature

Dave Peterson

Reply to this Message

benny - 26 Jan 2006 16:51 GMT

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 :)

> Can you use a third column and filter on that?
>
[quoted text clipped - 21 lines]
> >
> > Thx..

Reply to this Message