|
Spreadsheet Comparisons
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 |
Spreadsheet Comparisons
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 |
Spreadsheet Comparisons
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 |
Spreadsheet Comparisons
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 |
Spreadsheet Comparisons
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 |
| All times are GMT +1. The time now is 11:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com