Hello,
I wonder if I can trouble members for help.
I have a spreadsheet that, among other information, it has column A with over 400 rows of serial numbers (one per row) and column B the serial numbers that we have under warranty.
How can I find which of the serial numbers from column A are amongst the serial numbers of column B?
I've came across a number of suggestions online but they compare row in column A to same row in column B.
I need to take a number from column A and compare to all of the ones in column B and report a match.
Any help would be appreciated.
Bookmarks