Comparing cells when they are not exactly the same
 

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
--
Garry

Comparing cells when they are not exactly the same
 

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

1. are General Electric Company and General Motors Company similar enough ?
--
Gary''s Student
gsnu200712


"Garry" wrote:

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
--
Garry

Comparing cells when they are not exactly the same
 

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


"Gary''s Student" wrote:

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

1. are General Electric Company and General Motors Company similar enough ?
--
Gary''s Student
gsnu200712


"Garry" wrote:

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
--
Garry