asaravelli1234
New Member
- Joined
- Feb 3, 2021
- Messages
- 1
- Office Version
- 365
Hello everyone-
I have multiple spreadsheets each with a column that lists unique identifiers all with the same leading 3 letters, then several digits- I would like see if any of the whole identifiers (ABCXXXXX) listed in Spreadsheet A are present anywhere in the list of identifiers in Spreadsheet B, C, D, E and F. I am hoping there is an easy way to highlight and see what identifiers Spreadsheet A shares with any of the other lists. Is there anything that I can try to easily do this? Thanks very much in advance for your help
I have multiple spreadsheets each with a column that lists unique identifiers all with the same leading 3 letters, then several digits- I would like see if any of the whole identifiers (ABCXXXXX) listed in Spreadsheet A are present anywhere in the list of identifiers in Spreadsheet B, C, D, E and F. I am hoping there is an easy way to highlight and see what identifiers Spreadsheet A shares with any of the other lists. Is there anything that I can try to easily do this? Thanks very much in advance for your help