Compare cells (advanced)
 

Hi there.

I need to find a smart solution for comparing cells in an Excel file.
To make a long story short, we usually receive excel sheets with
thousands of rows. From a certain data there we make our own
extraction from our database and put that in the same sheet, next to
the other data.
Then we need to compare some data, to make sure that it is correct.
Lets say that we are comparing names. The problem is that VERY often
the two cells containing the names are not _exactly_ the same. There
might for example be one letter misspelled in one of the cells e.g.
(Mike Brown/Mike Bruwn) or in one cell lastname-firstname and in the
other firstname-lastname and so on.
Does anyone know of a good solution to make a "smart" comparision
between cells? In that sense that it maybe gives back a precentage or
something of how well they correspond to eachother?

Regards
/Matt