Spreadsheet Comparisons

D

dah

I have two lists of end users - one for 2001-2005 and one for 1998-2003.
Since there is an overlap in years 2001-2003, is there a way I can
compare the two spreadsheets using the computer instead of having to
manually compare names?


Deb
 
M

Miguel Zapico

You can use a formula like:
=IF(ISERROR(MATCH(A1,Sheet2!$A$1:$A$1000)),"Unique","Repeated")
This will show if the value in cell A1 of the current sheet is present in
the range A1:A1000 of sheet A2, change it as needed. You can copy the
formula beside the listing, and drag it along the column.

Hope this helps,
Miguel.
 
D

Dave Peterson

I bet you wanted:

=IF(ISERROR(MATCH(A1,Sheet2!$A$1:$A$1000,0)),"Unique","Repeated")

(and extra ",0" was added)
 
Top