Thread: Comparing Data - MS Excel
View Single Post
 
Old 05-19-2011, 05:52 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi
Try this formula:

=IF(ISNA(MATCH(Sheet1!A1,Sheet2!A:A,0)),Sheet1!A1, "")

You will then need to filter your Sheet 3 column A for non-blank cells.
Hope this helps.
Tony
Reply With Quote