View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
petevang
 
Posts: n/a
Default Comparing 2 lists side by side


I have two lists of data in columns A and B. I'd like to see which
cells do not appear in column B that are listed in Column A. Any idea
how to do this? For example:
A B
1 1
2 3
3 5
4 7

I'd like to be able to see that 2 and 4 do not appear in column B

:) :) :)


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=530913