I have 2 looong lists of hundreds of account ID numbers. I need to compare the lists and find which, if any, of the same ID numbers appear on both lists. These are on 2 different spreadsheets, and I must compare to identify which accounts appear on both spreadsheets. I am using Excel 2003.
Somewhat new to this world... Any help would be appreciated.
Somewhat new to this world... Any help would be appreciated.