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


--
dah
------------------------------------------------------------------------
dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=567557

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.

"dah" wrote:


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


--
dah
------------------------------------------------------------------------
dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=567557

I bet you wanted:

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

(and extra ",0" was added)

Miguel Zapico wrote:

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.

"dah" wrote:


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


--
dah
------------------------------------------------------------------------
dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=567557



--

Dave Peterson

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

"Dave Peterson" wrote:

I bet you wanted:

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

(and extra ",0" was added)

Miguel Zapico wrote:

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.

"dah" wrote:


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


--
dah
------------------------------------------------------------------------
dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=567557



--

Dave Peterson

Thanks. Worked well.


--
dah
------------------------------------------------------------------------
dah's Profile: http://www.excelforum.com/member.php...fo&userid=6493
View this thread: http://www.excelforum.com/showthread...hreadid=567557