Hello,
I have a file with 32,000+ lines. One column includes company names and another includes account numbers. The column with company names has many partial matches, such as Microsoft Corp vs. Microsoft Corp. vs. Microsoft Corporation, some with the same account numbers and some with different.
What formula should I use to identify the unique line items based on both the company names (deduped for partial matches) and the account numbers? I believe there's something with =LEFT formula and =COUNTIF, but I couldn't figure it out.
Thank you!
Bookmarks