Consider using AutoFilter:

Data Filter... AutoFilter (Custom...) Contains

This will allow you to display and count similar names like
Ford
Ford Motor Company


etc.
--
Gary''s Student - gsnu200795


"Anders" wrote:

Hi,

I have a very big excel worksheet (35 000 ++) with company names where I'm
trying to find duplicates, but also company names that are very similar.
Meaning names that are almost the same, but some might differ slightly but
still representing the same company. Is it possible to write a formula in
excel that can help me with this problem?

Many thanks!