how to find a value in one column that is not in another column in
 

Hello:

I have two columns. Not all of the values in the first column are in the
second column. (Some are, some aren't.)

What formula in Excel can I use to say "hey, return the values from the
first column that are not in the second column"?

Thanks!

childofthe1980s

how to find a value in one column that is not in another column in
 

You can mark then

assume column A and column M
in B1
=countif(M:M,A1)

then drag fill down the column.

--
Regards,
Tom Ogilvy




"childothe1980s" wrote:

Hello:

I have two columns. Not all of the values in the first column are in the
second column. (Some are, some aren't.)

What formula in Excel can I use to say "hey, return the values from the
first column that are not in the second column"?

Thanks!

childofthe1980s