View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
petevang
 
Posts: n/a
Default comparing two lists in excel


I have two columns of data (A and B) whos cells consist of only numbers
in order from 1 to 50. Columns A's ranges from 1 to 50, and every
whole number is present. Column B is missing a few numbers. I want to
see what numbers are not in column B but are in column A. Is their a
formula that could highlight the missing cells?:)


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