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

[childothe1980s]

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

[Tom Ogilvy]

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