Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Compare cells | Excel Discussion (Misc queries) | |||
How do you compare text in cells | Excel Worksheet Functions | |||
How do I compare cells in a column | New Users to Excel | |||
Help adding text values | Excel Worksheet Functions |