Guys, it's great to be visiting this board after years as I am faced with the following challenge.
Note: Please ignore the phone numbers/digits in the cells when matching. We are only focusing on the names, but we are moving the exact entry (along with the phone numbers) to the appropriate column. In the entire exercise as we are arranging cells, original order is preferred in case of multiple exact matches etc. Phone numbers have been hidden and/or jumbled for privacy.
Here's the task.
I have data in four columns as is shown in the image I've attached.
I am looking for a match (exact or partial) on a row by row only basis.
I am looking to arrange the entries in columns B,C, and D by matching the corresponding entries in each column to entry in column A.
I would like to arrange the entry that best matches column A from the corresponding entries in columns B,C and D in column E, 2nd best matched entry in F, and third best entry in Column G.
If any corresponding cell in columns B,C, and D has no match (we are ignoring the numbers/digits completely) with cell A then we are still arranging the remaining corresponding entries in order while puting No Match in the cell that doesn't match at all.
I would either like a formula that I could paste in cells E, F, and G, or a macro that would resolve this issue.
Note: We are moving both the name and phone although we are not interested in matching the phone with column A obviously. (Column A has no digits to match, only names)
If there are exact matches of names found in multiple columns, then the original order is to be kept.
Looking for a speedy resolution from some of the pros on this board.
Thanks in advance.
Note: Please ignore the phone numbers/digits in the cells when matching. We are only focusing on the names, but we are moving the exact entry (along with the phone numbers) to the appropriate column. In the entire exercise as we are arranging cells, original order is preferred in case of multiple exact matches etc. Phone numbers have been hidden and/or jumbled for privacy.
Here's the task.
I have data in four columns as is shown in the image I've attached.
I am looking for a match (exact or partial) on a row by row only basis.
I am looking to arrange the entries in columns B,C, and D by matching the corresponding entries in each column to entry in column A.
I would like to arrange the entry that best matches column A from the corresponding entries in columns B,C and D in column E, 2nd best matched entry in F, and third best entry in Column G.
If any corresponding cell in columns B,C, and D has no match (we are ignoring the numbers/digits completely) with cell A then we are still arranging the remaining corresponding entries in order while puting No Match in the cell that doesn't match at all.
I would either like a formula that I could paste in cells E, F, and G, or a macro that would resolve this issue.
Note: We are moving both the name and phone although we are not interested in matching the phone with column A obviously. (Column A has no digits to match, only names)
If there are exact matches of names found in multiple columns, then the original order is to be kept.
Looking for a speedy resolution from some of the pros on this board.
Thanks in advance.
