I have a set of ID's and numbers - For example,
ABC - 123.45 ABC - 123.45 ABC - 123.44 CDE - 123.45 ABC - 123.33
Now, if I wanted to match things that were exactly the same, that's really easy - Create a unique ID with the letters and numbers, and do a match/vlookup on it to find ones that are the same to pair them with each other. My question is, how can I do a "fuzzy pairing" within a given tolerance?
One idea I have is this - for a .10 tolerance, I can have my unique ID be =A1&Round(B1,1), then do an exact match with that. Are there any other ways to do matching with some tolerance built in?