Fuzzy Matching for Multiple Excel Table (Reconciliation)

Поділитися
Вставка
  • Опубліковано 21 жов 2024
  • 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.excelsupers...
    To Buy an Excel Course visit: www.courses.exc...
    Subscribe to the Channel: / excelsuperstar

КОМЕНТАРІ • 64

  • @gssalian1
    @gssalian1 2 місяці тому +1

    Very informative video..... thank you.....

  • @brijlalsharma8329
    @brijlalsharma8329 29 днів тому

    YOU ARE GREAT EXCEL SUPERSTAR

  • @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

  • @sushovandutta9864
    @sushovandutta9864 3 місяці тому

    Excellent illustration.

  • @learnwithdkg
    @learnwithdkg 2 роки тому

    Mujhe isme sikhne ko mila aapka bahut bahut dhanyawad

  • @therealcreation...3427
    @therealcreation...3427 2 роки тому +1

    I really like your channel
    Love from Pakistan 🇵🇰

  • @indian35556
    @indian35556 11 місяців тому

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

  • @virendrahardiya2797
    @virendrahardiya2797 Рік тому

    Very Interesting and useful knowledge for me, thank u sir

  • @reachmaqsood
    @reachmaqsood 4 місяці тому

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

  • @encourageeducation704
    @encourageeducation704 4 місяці тому

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

  • @sandeepmukherjee3998
    @sandeepmukherjee3998 2 роки тому

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

  • @canirmalchoudhary8173
    @canirmalchoudhary8173 2 роки тому

    Amazing Fuzzy matching- jaccard index

  • @Motivational_Inner_waves
    @Motivational_Inner_waves 2 роки тому

    Splendid tricks very useful

  • @Rahul_Seth
    @Rahul_Seth 2 роки тому +1

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

  • @satishchaurasia84ya
    @satishchaurasia84ya 2 роки тому

    Perfect👍👏👏 Greatest video as always. Thanks

  • @khalidalisubhanallah2947
    @khalidalisubhanallah2947 2 роки тому

    Very knowledgeable video

  • @nishushroff9656
    @nishushroff9656 Рік тому

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

  • @ashishshiriskar123
    @ashishshiriskar123 2 роки тому

    Sir as usual you're superb 👍

  • @ashutoshgarg9198
    @ashutoshgarg9198 Рік тому +1

    Not getting fussy match option please help 5:29

  • @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

  • @RahulRoy-po9ct
    @RahulRoy-po9ct 5 місяців тому

    🙏SIR PRANAM🙏

  • @srivalli7089
    @srivalli7089 2 роки тому

    excellent .... thanks

  • @aptech9254
    @aptech9254 8 місяців тому

    Awesome 👍

  • @bhimkunwor3894
    @bhimkunwor3894 2 роки тому

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

  • @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 роки тому +1

      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 Рік тому +1

      #Excellent #Excellent #Excellent
      _Great Explain SirJi+

  • @alokedhara8443
    @alokedhara8443 2 роки тому

    Just awesome 👍👍

  • @learnwithdkg
    @learnwithdkg 2 роки тому

    This is new for me in power

  • @pravinkumbhare1750
    @pravinkumbhare1750 2 роки тому

    Very useful... Sir..

  • @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 .

  • @JITENDRAKUMAR-yy8jy
    @JITENDRAKUMAR-yy8jy 2 роки тому

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

  • @SanviPatil2019
    @SanviPatil2019 2 роки тому

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

  • @aravrathor5595
    @aravrathor5595 2 роки тому

    Excellent

  • @karteekk6905
    @karteekk6905 2 роки тому

    Thank you bro..

  • @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.

  • @satscoolstyle4210
    @satscoolstyle4210 2 роки тому

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

  • @waniashfaq123
    @waniashfaq123 2 роки тому +1

    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

  • @vimaldewangan9309
    @vimaldewangan9309 2 роки тому

    Very interesting

  • @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

  • @dafdaanil1979
    @dafdaanil1979 Рік тому

    Good 👍

  • @Bhavik_Khatri
    @Bhavik_Khatri 2 роки тому

    Very nice vid

  • @mamalik1088
    @mamalik1088 2 роки тому

    Pls make more videos about fuzzy BI

  • @Priyankbhatt4
    @Priyankbhatt4 2 роки тому

    Nice videos

  • @darylmendonca874
    @darylmendonca874 Рік тому

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

  • @sudhakardevaraj6066
    @sudhakardevaraj6066 2 роки тому

    Great sir

  • @prajnanks
    @prajnanks 2 роки тому

    Super sir👌👌👌👌

  • @shaikhhossain4762
    @shaikhhossain4762 2 роки тому

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

  • @nishushroff9656
    @nishushroff9656 Рік тому

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

  • @azizkhan5135
    @azizkhan5135 2 роки тому

    Nice.

  • @NileshYadav-vt3iq
    @NileshYadav-vt3iq 2 роки тому

    Please also make a Power BI videos sir

  • @4HCreation
    @4HCreation Рік тому

    great

  • @chandanprasad4959
    @chandanprasad4959 8 місяців тому

    Sir I didn't find the Fuzzy option.

  • @techanil6835
    @techanil6835 2 місяці тому

    Nice

  • @Rahul_Seth
    @Rahul_Seth 2 роки тому

    But sir 2013 version me ye *fuzzy matching* wala option nahi aa raha hai

  • @dayalsonmanish
    @dayalsonmanish 2 роки тому

    Sir excel 2013 me power query download karne ke baad Fuzzy match ka option nahi aaraha

  • @chandanprasad4959
    @chandanprasad4959 Рік тому

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

  • @sonalijain3497
    @sonalijain3497 2 роки тому

    Vedio is blure unable to see clearly