Spreadsheet Comparisons

[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

 

[Guest]

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.

 

[Dave Peterson]

I bet you wanted:

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

(and extra ",0" was added)

 

[Guest]

Yes, you are right. The zero is needed for exact matches, sorry.

 

[dah]

Thanks. Worked well.