Thread
:
Find the differences in 2 columns
View Single Post
#
2
Posted to microsoft.public.excel.misc
papou
external usenet poster
Posts: 110
Find the differences in 2 columns
Hello Bec
Place this array (validate with ctrl+shift+enter) formula in C1 and fill
down:
=IF(COUNTIF($B1:$B$6,A1)=0;A1;"")
HTH
Cordially
Pascal
"Bec" a écrit dans le message de news:
...
Hi
I have 2 columns of data with lots of data replicated in both columns,
I am trying to find out the data from column A that is not replicated
in Column B
ie:
Column A column B
cynthia olivia
olivia bob
bob bruce
greg greg
judy Sam
gwen
so the answer I'm looking for in the above example would be cynthia,
judy and gwen as they only appear in column A and not in column B. I
do not need to know about Bruce or Sam as they are in column B but not
in column A - if that makes sensse.
Thanks for any help
Cat
Reply With Quote
papou
View Public Profile
Find all posts by papou