I need to compare 2 spreadsheets daily to find numbers that match and which ones are left over.
The first list of numbers would be in column A in one spreadsheet and the second list in column A of another spreadsheet.
Is there a quick way to identify matching numbers so I don't have to eyeball the entire list, highlighting each match as i work my way down?
I appreciate any ideas!
Bookmarks