Computers Microsoft Excel - How often do you use it? - Page 8

Coach · 12-08-2018, 03:09 PM

For advanced users, tell us some of your tricks in terms of using the formulas and such.

For beginners, ask questions here, hopefully answers could be provided.

As for me, my question to the experts/advanced users,

Let's say if I have a spreadsheet with column A that has names, typically last name, first name and middle initial (example: Smith, Joe Steve). Column B has names that is typically the same as column A, except it would be missing the middle name or a misspelling on the first name (example: Smith, Joe).

Column A would have say 450 names and Column B would have 150. How can a "near" match search be found, after utilizing the conditional formatting that highlights duplicate values?

12-08-2018, 03:09 PM	Topic Starter
Coach Champs! Join Date: Mar 2004 Location: Kansas City Casino cash: $5828476	Microsoft Excel - How often do you use it? For advanced users, tell us some of your tricks in terms of using the formulas and such. For beginners, ask questions here, hopefully answers could be provided. As for me, my question to the experts/advanced users, Let's say if I have a spreadsheet with column A that has names, typically last name, first name and middle initial (example: Smith, Joe Steve). Column B has names that is typically the same as column A, except it would be missing the middle name or a misspelling on the first name (example: Smith, Joe). Column A would have say 450 names and Column B would have 150. How can a "near" match search be found, after utilizing the conditional formatting that highlights duplicate values?
Posts: 53,221