Comparing cells when they are not exactly the same

G

Garry

I have 2 columns containing company names, but the formating is slightly
different in the two. For example, Column 1 contains "AON", column 2 "aon
consultancy" (which is the same company). How can i run a comparrison which
picks out similar data from parts of each cell. Obviously the "exact"
function wont work.

Any advice?

Cheers, Garry
 
G

Gary''s Student

All you need to do is to precisely define the criteria for "similar":

1. are General Electric Company and General Motors Company similar enough ?
 
G

Garry

Yes they would be. I've no experience of this though, so how would i go about
it??
 
Top