how can I flag the same data from two different column
try this
=COUNTIF($A$2:$A$4000,B2)=1
those names that are not in col B will return FALSE
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
"IBE" wrote:
I have a worksheet that I'm trying to find the data from Column A that's not
in Column B. i have almost 4000 records and it's a pain to go through each
row. help please.
|