Fuzzy Matching for Multiple Excel Table (Reconciliation)

Подписаться 385 тыс.

Просмотров 22 тыс.

50% 1

Create an automated reconciliation statement using Excel Power Query's Fuzzy Match. This is used when there are differences in spelling.
Excel Power Query - 5 Case Studies Under 60 Minutes
• Excel Power Query - 5 ...
Download Practice files - bit.ly/3sf2sHi
Fuzzy lookup Excel | Hindi
• Fuzzy lookup Excel | H...
Fuzzy Matching for Multiple Excel Table (Reconciliation)
#fuzzymatching #excelinhindi #Reconciliationstatement
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org...
Subscribe to the Channel: / excelsuperstar

Опубликовано:

23 фев 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 62

@sushovandutta9864 4 дня назад

Excellent illustration.

@reachmaqsood Месяц назад

Great video. Learnt a lot and will try it out now.

@encourageeducation704 Месяц назад

Thank you so much rishabh sir.. You are the great 👍🏻

@vishalbhati912 2 года назад

Fuzzy lookup aapke hi video se sikha tha mene. Jo ki bahot kaam ka video tha. Thank u iss video k liye bhi

@RahulRoy-po9ct Месяц назад

🙏SIR PRANAM🙏

@learnwithdkg 2 года назад

Mujhe isme sikhne ko mila aapka bahut bahut dhanyawad

@sandeepmukherjee3998 2 года назад

Very useful, thank you so much. Going to be savior once I start using it

@therealcreation...3427 2 года назад

I really like your channel Love from Pakistan 🇵🇰

@satishchaurasia84ya 2 года назад

Perfect👍👏👏 Greatest video as always. Thanks

@virendrahardiya2797 Год назад

Very Interesting and useful knowledge for me, thank u sir

@indian35556 8 месяцев назад

Video is not so lengthy. It is ok to learn. Thanks for your efforts.

@Rahul_Seth 2 года назад

I am really excited for this video Sir ❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️

@Motivational_Inner_waves 2 года назад

Splendid tricks very useful

@ashishshiriskar123 2 года назад

Sir as usual you're superb 👍

@aptech9254 4 месяца назад

Awesome 👍

@alokedhara8443 2 года назад

Just awesome 👍👍

@canirmalchoudhary8173 2 года назад

Amazing Fuzzy matching- jaccard index

@pravinkumbhare1750 2 года назад

Very useful... Sir..

@aravrathor5595 2 года назад

Excellent

@srivalli7089 2 года назад

excellent .... thanks

@karteekk6905 2 года назад

Thank you bro..

@mohammednaserullahkhan7241 2 года назад

Rehab, you are remarkable and thanks a lot for showing us an excellent solution, I have been searching for this query for a few months back but now I got the solution for yours's effort. Again a big thank you.

@ExcelSuperstar 2 года назад

There could be some differences in UI. Just in case, your Excel version doesn't support some features, remember you can practice all of this using the free Power BI Desktop.

@mohammednaserullahkhan7241 2 года назад

@@ExcelSuperstar Hi Reshab, I am using Excel 2016 version, in which I could not find the option "Merge Queries as New" in Query Editor since it could not getting the desired result which your showing in your latest Excel version. So please advice. Thanks.

@nurserytoys Год назад

#Excellent #Excellent #Excellent _Great Explain SirJi+

@khalidalisubhanallah2947 2 года назад

Very knowledgeable video

@SanviPatil2019 2 года назад

brilliant sir.. i like this video's.. rishabh sir pls make reconciliation video on two bank statement..

@dafdaanil1979 Год назад

Good 👍

@Bhavik_Khatri 2 года назад

Very nice vid

@Priyankbhatt4 2 года назад

Nice videos

@learnwithdkg 2 года назад

This is new for me in power

@sudhakardevaraj6066 2 года назад

Great sir

@prajnanks 2 года назад

Super sir👌👌👌👌

@azizkhan5135 2 года назад

Nice.

@vimaldewangan9309 2 года назад

Very interesting

@4HCreation Год назад

great

@ashutoshgarg9198 Год назад

Not getting fussy match option please help 5:29

@mamalik1088 2 года назад

Pls make more videos about fuzzy BI

@nishushroff9656 10 месяцев назад

How to get the similarity column as we get it after running fuzzy lookup in excel??? Pls answer asap

@NandaKishoreReddymuthayala Год назад

Thanks for this wonderful video. I have a question I tried applying this for a data set available with me after the results are derived I tried loading it into a new table in a new sheet, but the new sheet is just showing as 2lakh +rows loading and not returning any result in the sheet. Please help with this

@satscoolstyle4210 2 года назад

Sir mere pr ms office 2016 h pr mere mai ye saare option ni are like merge as new etc

@JITENDRAKUMAR-yy8jy 2 года назад

Sir, yahi same use hm amount pr b kar sakte h

@bhimkunwor3894 2 года назад

Can we use this function for Duplicate identify where diffrent spell used. can we use in single sheet

@NileshYadav-vt3iq 2 года назад

Please also make a Power BI videos sir

@darylmendonca874 Год назад

Fuzzy Matching option not getting in options... Only Joins is available

@relaxyourself8706 11 месяцев назад

How to add join kind

@Koreandrama431 2 года назад

Hello Rishabh, today I try to used BI but fuzzy Marge options not show 2019 virsion. Please suggest me what I do.

@ExcelSuperstar 2 года назад

Download free Power BI Desktop. You can practice it there.

@jaipalsingh1416 2 года назад

RISHABH, NEED YOUR HELP, I WANT TO SHOW FILTERED DATA FROM SAPARATE SHEET, COLOMN WISE .. LIKE I GET FILTERED DATA ROW-1 (COL-1,2,3), ROW-2 (COL-1,2,3) etc BUT I WANT TO DISPLAY ALL THE ROWS VALUES IN NEXT COLUMS - ROW1( {COL-1,2,3} , {COL-4,5,6} ) IS THERE ANY WAY .

@shaikhhossain4762 2 года назад

Nice Video. I am a CPA and living in Toronto. May I Contact you. Reson would discuss while communication establishes. Thanks

@chandanprasad4959 5 месяцев назад

Sir I didn't find the Fuzzy option.

@perfectinfotech8944 Год назад

Sir in this video I follow all steps but while merging two tables in box bellow I found only join kind box last two fuzzy and bellow tickmark option not visible

@darylmendonca874 Год назад

me too got the same... u got any solution?

@chaitanyasunny5872 10 месяцев назад

Same here

@nishushroff9656 10 месяцев назад

This did not work for me. I got error " cant convert to numbers" after applying merge step Pls provide solution

@waniashfaq123 2 года назад

I am unable to install power query on excel 10....as it pop message Microsoft Power Query for Excel requires Internet Explorer 9 RTM or later. Please make sure that you have Internet Explorer 9 RTM or later installed.

@waniashfaq123 2 года назад

Sir, kindly read my comment what i want to told

@chandanprasad4959 Год назад

Sir, the video is a little blurry. Kindly make it clearer.