I have 30K rows listed in an excel sheet with random number separated by comma 671,962,116,029
Noting, the duplicate SIC Code could fall anywhere within the string. I need to identify the rows that have duplicates in them. The duplicate row could be highlight or column inserted to mark this row with a duplicate SIC Code.
an example of desired result - 101636,AIRLINES REPORTING CORPORATION,,,,,,,"7389,6099,7389"
The above row has duplicate and should be highlighted
Down below is more examples of the random numbers I am working with so you have clear idea
100011 XEROX CORPORATION 50,453,861
100041 BLUE LANCE INCORPORATED 73,727,371
100190 CIT COMMUNICATIONS FINANCE CORPORATION 4899
101172 ABN AMRO BANK NV 671,962,116,029
Thank you in advance so very much for your help.
Bookmarks