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

  • Thread starter Thread starter Tina
  • Start date Start date
T

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
 
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
 
Back
Top