Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I compare data from 2 worksheets to find duplicate entries
I am a novice Excel user. I have to worksheets that have data, some of it is
similar (ie. Item #'s, etc.) I want to automatically compare the reports and highlight data on one worksheet that is identicle to the data on the other worksheet. If I can't do this, I'm going to have to manually compare the data. |
#2
|
|||
|
|||
Jack,
A coded solution is probably the way to go for your challenge. You can iterate through each item on the first sheet and check to see if it exists in the second sheet before copying it to a new (report), third sheet. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Jack" wrote: I am a novice Excel user. I have to worksheets that have data, some of it is similar (ie. Item #'s, etc.) I want to automatically compare the reports and highlight data on one worksheet that is identicle to the data on the other worksheet. If I can't do this, I'm going to have to manually compare the data. |
#3
|
|||
|
|||
If those item numbers are unique, maybe you could use =vlookup() or
=index(match()) to retrieve values from the second worksheet and put it near the values in the first worksheet. You could look at Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html and http://www.contextures.com/xlFunctions03.html Jack wrote: I am a novice Excel user. I have to worksheets that have data, some of it is similar (ie. Item #'s, etc.) I want to automatically compare the reports and highlight data on one worksheet that is identicle to the data on the other worksheet. If I can't do this, I'm going to have to manually compare the data. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working with data between worksheets | Excel Discussion (Misc queries) | |||
Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
How do I compare 2 worksheets, 1 old, 1 updated to find difference | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions |