| 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. |
| 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 | |||
Threaded Mode
