Compress Duplicates in Table

[Flamberge]

So I have a simple 2-column table; basically just a list of names where each has a corresponding number. Simply, I want to comb through the list and find things like "| Company A | 5 |" and "| Company A Inc. | 5 |" and combine them. I guess this could turn into "| Company A | 10 |" or "| Company A Inc. | 10 |".

Any ideas on how to get started with this?

 

[mole999]

say your values are A1 and B1, in C1 =TRIM(SUBSTITUTE(A1&B1," Inc","")) drag down and then conditional format for duplicates

 

[sandy666]

I think you should show more representative data. Use OneDrive, GoogleDrive or any other similar and post link here to the shared excel file with example