Excluding in Excel
 

Hello
I have a question for Excel knowers

I have a list of items in column A
I also have a list of items in column B
Some of the items in A and B are duplicates
I'd like to obtain a C column sustaing of items that appear in column A but
NOT appear in column B

Can you help me solving my problem?
Please mail me on priv playa(at)poczta.fm

Kind Regards,
Jakub Lenczowski
Krakow, Poland

Excluding in Excel
 

Select enough cells in a separate column to cater for all the uniques, and
add this formula

=IF(ISERROR(SMALL(IF(COUNTIF($B1:$B20,$A$1:$A$20)= 0,ROW($A1:$A20),""),ROW($A
1:$A20))),"",
INDEX($A$1:$A$20,SMALL(IF(COUNTIF($B1:$B20,$A$1:$A $20)=0,ROW($A1:$A20),""),R
OW($A1:$A20))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kuba" wrote in message
...
Hello
I have a question for Excel knowers

I have a list of items in column A
I also have a list of items in column B
Some of the items in A and B are duplicates
I'd like to obtain a C column sustaing of items that appear in column A
but
NOT appear in column B

Can you help me solving my problem?
Please mail me on priv playa(at)poczta.fm

Kind Regards,
Jakub Lenczowski
Krakow, Poland