filtering 2 Excel sheets

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

Does anyone know how to overlay 2 spreadsheets and get the
unmatched data????

for example..column a has 200 items on 1 sheet

column a has 100 items on spreadsheet 2

I would like a third spreadsheet to show the differences
between spreadsheet 1 and 2

Thanks
 
Copy the values from both sheets into a third sheet that will get 300 items,
use a help column (I assume you use column A for the items and B as help)

In B2 put

=COUNTIF($A$2:$A$302,A2)

now apply data>autofilter, filter on B and select 1

copy the items from the visible A to a 4th sheet and they will be the
difference,
if the end result should be to remove all duplicates use the advanced filter
on the large help list
and select copy to another location and unique records only



=--

Regards,

Peo Sjoblom
 
Back
Top