| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I compare data in two worksheets to find matching cells?
Each day I work with two worksheets. One is a list of numbers that is given
to me by someone else. The other list is something I make myself, again it is a list of numbers. I need to know if there is a way I can compare the data to find out if any of the numbers I input on my list match up to the ones on the list I am given. I am aware of the "Find" function, but I'm working with lists of hundreds of numbers, and it's really annoying to take each one and "find" it on another worksheet. Any answers? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Threaded Mode
