Fuzzy Matching for Multiple Excel Table (Reconciliation)

  Рет қаралды 22,909

Excel Superstar

Excel Superstar

Күн бұрын

Пікірлер: 65
@brijlalsharma8329
@brijlalsharma8329 2 ай бұрын
YOU ARE GREAT EXCEL SUPERSTAR
@gssalian1
@gssalian1 3 ай бұрын
Very informative video..... thank you.....
@sushovandutta9864
@sushovandutta9864 4 ай бұрын
Excellent illustration.
@vishalbhati912
@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
@therealcreation...3427
@therealcreation...3427 2 жыл бұрын
I really like your channel Love from Pakistan 🇵🇰
@encourageeducation704
@encourageeducation704 5 ай бұрын
Thank you so much rishabh sir.. You are the great 👍🏻
@reachmaqsood
@reachmaqsood 5 ай бұрын
Great video. Learnt a lot and will try it out now.
@virendrahardiya2797
@virendrahardiya2797 Жыл бұрын
Very Interesting and useful knowledge for me, thank u sir
@learnwithdkg
@learnwithdkg 2 жыл бұрын
Mujhe isme sikhne ko mila aapka bahut bahut dhanyawad
@indian35556
@indian35556 Жыл бұрын
Video is not so lengthy. It is ok to learn. Thanks for your efforts.
@satishchaurasia84ya
@satishchaurasia84ya 2 жыл бұрын
Perfect👍👏👏 Greatest video as always. Thanks
@canirmalchoudhary8173
@canirmalchoudhary8173 2 жыл бұрын
Amazing Fuzzy matching- jaccard index
@bongsandym
@bongsandym 2 жыл бұрын
Very useful, thank you so much. Going to be savior once I start using it
@Rahul_Seth
@Rahul_Seth 2 жыл бұрын
I am really excited for this video Sir ❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️
@aptech9254
@aptech9254 9 ай бұрын
Awesome 👍
@enayatadil7503
@enayatadil7503 23 күн бұрын
Zabardast
@RahulRoy-po9ct
@RahulRoy-po9ct 6 ай бұрын
🙏SIR PRANAM🙏
@ashishshiriskar123
@ashishshiriskar123 2 жыл бұрын
Sir as usual you're superb 👍
@khalidalisubhanallah2947
@khalidalisubhanallah2947 2 жыл бұрын
Very knowledgeable video
@aravrathor5595
@aravrathor5595 2 жыл бұрын
Excellent
@Motivational_Inner_waves
@Motivational_Inner_waves 2 жыл бұрын
Splendid tricks very useful
@mohammednaserullahkhan7241
@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
@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
@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
@nurserytoys Жыл бұрын
#Excellent #Excellent #Excellent _Great Explain SirJi+
@dafdaanil1979
@dafdaanil1979 Жыл бұрын
Good 👍
@Bhavik_Khatri
@Bhavik_Khatri 2 жыл бұрын
Very nice vid
@pravinkumbhare1750
@pravinkumbhare1750 2 жыл бұрын
Very useful... Sir..
@srivalli7089
@srivalli7089 2 жыл бұрын
excellent .... thanks
@alokedhara8443
@alokedhara8443 2 жыл бұрын
Just awesome 👍👍
@Priyankbhatt4
@Priyankbhatt4 2 жыл бұрын
Nice videos
@prajnanks
@prajnanks 2 жыл бұрын
Super sir👌👌👌👌
@karteekk6905
@karteekk6905 2 жыл бұрын
Thank you bro..
@learnwithdkg
@learnwithdkg 2 жыл бұрын
This is new for me in power
@NandaKishoreReddymuthayala
@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
@azizkhan5135
@azizkhan5135 2 жыл бұрын
Nice.
@nishushroff9656
@nishushroff9656 Жыл бұрын
How to get the similarity column as we get it after running fuzzy lookup in excel??? Pls answer asap
@vimaldewangan9309
@vimaldewangan9309 2 жыл бұрын
Very interesting
@sudhakardevaraj6066
@sudhakardevaraj6066 2 жыл бұрын
Great sir
@SanviPatil2019
@SanviPatil2019 2 жыл бұрын
brilliant sir.. i like this video's.. rishabh sir pls make reconciliation video on two bank statement..
@techanil6835
@techanil6835 3 ай бұрын
Nice
@bhimkunwor3894
@bhimkunwor3894 2 жыл бұрын
Can we use this function for Duplicate identify where diffrent spell used. can we use in single sheet
@4HCreation
@4HCreation Жыл бұрын
great
@mamalik1088
@mamalik1088 2 жыл бұрын
Pls make more videos about fuzzy BI
@JITENDRAKUMAR-yy8jy
@JITENDRAKUMAR-yy8jy 2 жыл бұрын
Sir, yahi same use hm amount pr b kar sakte h
@ashutoshgarg9198
@ashutoshgarg9198 Жыл бұрын
Not getting fussy match option please help 5:29
@NileshYadav-vt3iq
@NileshYadav-vt3iq 2 жыл бұрын
Please also make a Power BI videos sir
@Koreandrama431
@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
@ExcelSuperstar 2 жыл бұрын
Download free Power BI Desktop. You can practice it there.
@shaikhhossain4762
@shaikhhossain4762 2 жыл бұрын
Nice Video. I am a CPA and living in Toronto. May I Contact you. Reson would discuss while communication establishes. Thanks
@jaipalsingh1416
@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 .
@satscoolstyle4210
@satscoolstyle4210 2 жыл бұрын
Sir mere pr ms office 2016 h pr mere mai ye saare option ni are like merge as new etc
@perfectinfotech8944
@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
@darylmendonca874 Жыл бұрын
me too got the same... u got any solution?
@chaitanyasunny5872
@chaitanyasunny5872 Жыл бұрын
Same here
@darylmendonca874
@darylmendonca874 Жыл бұрын
Fuzzy Matching option not getting in options... Only Joins is available
@chandanprasad4959
@chandanprasad4959 9 ай бұрын
Sir I didn't find the Fuzzy option.
@waniashfaq123
@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
@waniashfaq123 2 жыл бұрын
Sir, kindly read my comment what i want to told
@nishushroff9656
@nishushroff9656 Жыл бұрын
This did not work for me. I got error " cant convert to numbers" after applying merge step Pls provide solution
@chandanprasad4959
@chandanprasad4959 Жыл бұрын
Sir, the video is a little blurry. Kindly make it clearer.
@Rahul_Seth
@Rahul_Seth 2 жыл бұрын
But sir 2013 version me ye *fuzzy matching* wala option nahi aa raha hai
@rishabhpugalia9281
@rishabhpugalia9281 2 жыл бұрын
Download Power BI to practice it.
@dayalsonmanish
@dayalsonmanish 2 жыл бұрын
Sir excel 2013 me power query download karne ke baad Fuzzy match ka option nahi aaraha
@sonalijain3497
@sonalijain3497 2 жыл бұрын
Vedio is blure unable to see clearly
Merge Queries in Power Query (WHY - Handle Speed & Volume)
37:49
Excel Superstar
Рет қаралды 29 М.
Power Query Fuzzy Matching (Automated reconciliation)
9:37
Yoda Learning Academy
Рет қаралды 13 М.
This Game Is Wild...
00:19
MrBeast
Рет қаралды 140 МЛН
Кто круче, как думаешь?
00:44
МЯТНАЯ ФАНТА
Рет қаралды 5 МЛН
小路飞还不知道他把路飞给擦没有了 #路飞#海贼王
00:32
路飞与唐舞桐
Рет қаралды 86 МЛН
The Singing Challenge #joker #Harriet Quinn
00:35
佐助与鸣人
Рет қаралды 42 МЛН
Pivot Table Excel in 28 Minutes - Pivot Table Excel in Hindi
27:50
Excel Superstar
Рет қаралды 327 М.
Top 10 Printing Tricks & Settings in Excel | Excel Printing
11:13
Excel Superstar
Рет қаралды 41 М.
OFFSET Formula in Excel (Hindi) | OFFSET function
9:27
Excel Superstar
Рет қаралды 41 М.
How To Use Excel's 4 Match Types (Partial, Exact, Fuzzy, Approximate)
14:35
How to Use Microsoft Excel Fuzzy Lookup
11:28
Wisdom by Data
Рет қаралды 22 М.
Fuzzy Lookup and Vlookup with wildcards
20:39
Research Methodology Advanced Tools
Рет қаралды 513
This Game Is Wild...
00:19
MrBeast
Рет қаралды 140 МЛН