View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
salut salut is offline
external usenet poster
 
Posts: 31
Default Compare data in two columns

Match(B1,A:A,0)

"excellearn2006" wrote:

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other