Forum Discussion
NativeWest
Jul 08, 2024Copper Contributor
Macro or formula to analyze data in a range for similar data in another range
Hi,
I'm not even sure if this is possible but I'm hoping to find a way to have excel make a best guess and return the value in a dataset. Using the example below Excel would read the values in column D and enter the closest match from column F next to it in column E. So FACBK*3VCAQ3YFL2 would result "Facebook" in cell E2. I'm not looking for perfection, just a head start.
Thank you in advance!
Ryan
1 Reply
Sort By
- peiyezhuBronze Contributorfuzzy match
find minium edit distance?https://techcommunity.microsoft.com/t5/excel/aligning-1st-and-last-name-column-in-excel-with-similar-jpg-file/m-p/3889608