Hi Scott, Nice video! Thanks a lot. But let me tell you three things to make your Excel life easy: 1. Do NOT select all data but click in the data area, anywhere and press . Done! 2. To adjust column widths, do NOT drag the columns one by one. Click the triangle left of A and over 1 and double click any of the column separators. Done! 3. To get rid of non-matching rows: select the first and press . Delete and done! By the way: I have used Fuzzy Lookup before and indeed: it can be very useful. So thanks again for this clip.
Fuzzy lookup is cool, but what I REALLY want is to just use it as a FUNCTION, instead of creating an entirely new table. Is there a function that can do that without me having to pay for a license? Thanks in advance!
Looks like this software doesnt check spelling errors if lengths of words don't match. So for example your cel A11 says "Avaya". If this was spelled "Avayaa" in your 2nd tab, it wouldn't find it (0% match). Or is there somekind of work-around for this?
Want to update one thing. For large names in large datasets, Ricoh Private Limited and Ricoh Pvt. Ltd. will match at around 0.78. Can you let me know how to check for duplicates using the same?
I'm using Fuzzy Lookup to match full names and e-mails. I'm wondering if it's better to concatenate First and Last or leave them in their separate fields.
I typically don't concatenate just to account for variations in first name - i.e. Rob/Robert, Mike/Michael - so I match on Last Name then review the first names.
![[UNCUT]“ฅนตื่นธรรม”ปะทะ“หมอปลา-ปู่มหามุนี-อั๋นโอกิ”สะเทือนกระทรวงเวทมนตร์ Iคนดังนั่งเคลียร์I10 ตค.67](http://i.ytimg.com/vi/peMD_SAkwNc/mqdefault.jpg)
Hi Scott,
Nice video! Thanks a lot.
But let me tell you three things to make your Excel life easy:
1. Do NOT select all data but click in the data area, anywhere and press . Done!
2. To adjust column widths, do NOT drag the columns one by one.
Click the triangle left of A and over 1 and double click any of the column separators. Done!
3. To get rid of non-matching rows: select the first and press . Delete and done!
By the way: I have used Fuzzy Lookup before and indeed: it can be very useful. So thanks again for this clip.
Excellent, saved me about 10,000,000 hours of my life!
I shall reflect wht everyone prior has said: YOU. ARE. THE. MAN. Hugely helpful. Thanks!
What if I only have 1 table of data, but I think I have duplicate entries (maybe not identically formatted). How can I find dupes within one table?
Thank you so much! I had the exact same problem and you're a life saver!
This is awesome, exactly what I need. Thanks Scott
Fuzzy lookup is cool, but what I REALLY want is to just use it as a FUNCTION, instead of creating an entirely new table. Is there a function that can do that without me having to pay for a license? Thanks in advance!
easy to understand. very helpful. thank you.
Thank you! This helped me a ton for a case study
I have a table with company names and street addresses. Would you recommend using this
Looks like this software doesnt check spelling errors if lengths of words don't match. So for example your cel A11 says "Avaya". If this was spelled "Avayaa" in your 2nd tab, it wouldn't find it (0% match). Or is there somekind of work-around for this?
Thank you so much. Saved my ass a thousand times. :). People think I'm a miracle worker.
Helpful video sir! Thank you very much!!!
Want to update one thing. For large names in large datasets, Ricoh Private Limited and Ricoh Pvt. Ltd. will match at around 0.78.
Can you let me know how to check for duplicates using the same?
I'm using Fuzzy Lookup to match full names and e-mails. I'm wondering if it's better to concatenate First and Last or leave them in their separate fields.
I typically don't concatenate just to account for variations in first name - i.e. Rob/Robert, Mike/Michael - so I match on Last Name then review the first names.
Very helpful, thank you so much!
Well done! Thank you.
Thanks, very helpful.
Great video. Thanks.
Awesome post
Hey! I cannt find the link.. ( Could you post it?
+Daniel Böttcher Sorry, I have it www.microsoft.com/en-us/download/details.aspx?id=15011
im having problems comparing a fuzzy set i currently have is there anyone who could help me, or any links that may be helpful
Thanks! :)
Greats....thanks
Very helpful! thanks!