using excel to compare two worksheets

[Rodney Peterson]

I have two work sheets, one worksheet "RASTER" contains
data like:

458
688
689
1208
1209
1651
1847
1848
2403
2404
2606
2616
2675
2677
6121
6609
6690
6691

and the other worksheet PRO-E contains data like:

689
1209
2616
2677
2830
2869
2870
2873
6695
7014
7399
8575
9098
9747
13405
13529
15992
16196

as you can see the two lists contain values with exact
matches and also don't have matches.
What I want to do is combine or compare the two worksheets
and only show me what does not match.
I only am concerned with keeping none matching values from
worksheet RASTER.

Thanks.

Rodney

 

[Dave Peterson]

Another option is to use Match:

=if(isnumber(match(a1,'pro-e'!$a$1:$a$9999,0)),"match","diff")
and the opposite on the other sheet:
=if(isnumber(match(a1,'raster'!$a$1:$a$9999,0)),"match","Diff")

And Chip Pearson has a bunch of techniques for working with duplicates at:

http://www.cpearson.com/excel/duplicat.htm