Column C has Only cells from col. A that are not found in col.B

[Tina]

Please help

I have two columns A and B. The cells in column B are a subset of the
values in column A. I need to displat the "complement of this subset"
- i.e. in column C, I need to display only the Column A cells that are
not found in column B. for example:

A B C
1 2 1
2 4 3
3 6 5
4 7 6
5
6
7

Thank you for your kind help

 

[Tina]

Oh, sorry - I noticed a mistake in my example - below my original post
without the mistake. Sorry about that!

(e-mail address removed) (Tina) wrote:

Please help

I have two columns: A and B. The cells in column B are a subset of
the
values in column A. I need to displat the "complement of this subset"
- i.e. in column C, I need to display only the Column A cells that are
not found in column B. for example:

A B C
1 2 1
2 4 3
3 6 5
4 7
5
6
7

Thank you for your kind help

 

[J.E. McGimpsey]

See "Extracting Unique Entries" at Chip Pearson's site:

http://cpearson.com/excel/duplicat.htm#ExtractingUnique

 

[Tina]

See "Extracting Unique Entries" at Chip Pearson's site:

http://cpearson.com/excel/duplicat.htm#ExtractingUnique

Thanks a lot!! The site says to put
=IF(COUNTIF($A$1:$A$10,B1)=0,B1,"")
into column C.

I just tried it and it works.

Thank you!