View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
petevang[_4_] petevang[_4_] is offline
external usenet poster
 
Posts: 1
Default comparing side-by-side lists


I have two lists only containing numbers in columns A and B. How can I
see which cells are not in Column B that are in Column A? For
Example:

Cloumn A Column B
1 1
2 2
3 4
4 6
5 7
6 8
7 9
8
9
10

Is there a way that I can have excel return the missing values from
column B (3,5,10)

Thanks


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