Hello
I have a very large spreadsheet with ~10,000 rows and data in columns A - AK. I need to be able to identify any cells where the text in Column B matches any other cell in Column B and then display the data in Column A for those matches...
A B Expected Output
154 OrangeRed 1531, 7898
2504 RedYellow
5134 BluePink
1531 OrangeRed 154, 7898
8645 GreenBlue
5484 BluePink
7898 OrangeRed 154, 1531
1235 YellowGreen
Any help would be greatly appreciated!
Thanks and Regards
Bookmarks