View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cpviv Cpviv is offline
external usenet poster
 
Posts: 14
Default Two columns of data - How to get the unmatching cell data to colum

Hi,

I have column A with 95 cells data and column B with 183 cells data.
Column A has some cells data that not match with column B cells data.
How to get the unmatching data to column C?
At the same time, how to compare duplicates within two columns in a
spreadsheet?
--
Thank you,
Cpviv