Comparing cells when they are not exactly the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
All you need to do is to precisely define the criteria for "similar":

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using exact formula to compare cells 4
VBA Excel partial cell compare to another cell 0
Comparing Cells 1
compare 2 worksheets for simliar cells and then comb into one work 1
When data look exactly the same but... 4
Compare two worksheets with "contains" and not "exact" values 1
Finding keywords in several text columns 7
Compare part of a cell to a column 1

Back
Top