Hello Excel Forum!
So I am no Excel expert, I am a novice at best. My job has asked me to compare a list of device IDs (+30,000) to a few other list of IDs (a few thousand or a few hundred). I need to find what device IDs on the smaller lists are also on the large master list - if at all.
Is there a quick and 'easy' way to do this in excel? I do not want to go line by line - copy, pasting and finding until I have completed the list...that would take weeks!
Please let me know if you need more information or have any questions.
Thank you.
Bookmarks