How To Compare Two Excel Sheets in Hindi | Compare Excel Sheets For Differences | Excel in Hindi

Поділитися
Вставка
  • Опубліковано 3 січ 2025

КОМЕНТАРІ • 102

  • @Funnyment1990
    @Funnyment1990 3 місяці тому +1

    Very nice ....aj mere boss n yhi kaan diya tha maine 4hrs 😂😂lgaye

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

    Thank You Sir❣

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

    Thank you its working❤

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

    धन्यवाद साहेब तुमचे खुप खुप आभार 🙏🙏

  • @nalinikantadash8669
    @nalinikantadash8669 5 місяців тому

    Thank you so much.This video helped me a lot in my project.

  • @RamSharma-Talks
    @RamSharma-Talks 7 місяців тому

    Well explained👍

  • @soumendupahari4232
    @soumendupahari4232 5 місяців тому

    Very good sir and useful

  • @swetapaul209
    @swetapaul209 7 місяців тому

    Thanks bro it worked.

  • @NikhiSingh-rj7oq
    @NikhiSingh-rj7oq 6 місяців тому

    Thank you so much ,very usefull and working

  • @compliancedekho1948
    @compliancedekho1948 3 роки тому +1

    Very interesting and informative!!

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

    Thanks bro it worked

  • @vikramshinde3622
    @vikramshinde3622 3 роки тому

    Very nice. I like it. It's useful.

  • @UpendraSingh-my4xq
    @UpendraSingh-my4xq 3 роки тому

    Nice video keep it up brother

  • @kss2066
    @kss2066 3 роки тому +2

    good lesson! would love to learn more excel lessons from your channel

  • @Bhardwajvijay28
    @Bhardwajvijay28 3 роки тому +2

    This vedio is very useful. Can we compare more than two sheets?

    • @EasyExplain
      @EasyExplain  3 роки тому +1

      Yes. But in third sheet you have to apply conditional formatting again

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

      Which Excel version u r using ?😊

  • @pks0620
    @pks0620 3 роки тому

    Very useful 👌👍👍👍

  • @MIMGURU
    @MIMGURU 3 роки тому

    Very useful video,

    • @EasyExplain
      @EasyExplain  3 роки тому

      You're Welcome. Keep Sharing 🔃♥️👍🏻

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

    Well done sir

  • @UpendraSingh-my4xq
    @UpendraSingh-my4xq 3 роки тому

    Very informative

  • @junaidzakir9864
    @junaidzakir9864 3 роки тому

    Osmmm👌

  • @laveshghadi2200
    @laveshghadi2200 3 роки тому

    Thanks a lot sir jee

  • @0001-k2j
    @0001-k2j 3 роки тому

    Thanks 👍 information & download practice Link 🖇️🔗

    • @EasyExplain
      @EasyExplain  3 роки тому

      Link given in Video description.

  • @AMITKUMAR-qx3zk
    @AMITKUMAR-qx3zk Рік тому

    Kya hum 2 data sheet me se capital or small laterr ko bhi highlight kr skte h

  • @mann23800
    @mann23800 3 роки тому +1

    Very nice and thank you. Sir can we compare two work book data? Plz tell me!!

  • @faroukhpoacha1
    @faroukhpoacha1 2 роки тому +13

    I am doing exactly the same as you have demonstrated and am getting the "Error : you cannot use references to other worksheets or workbooks for conditional formatting criteria"

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

      Yes mine also

    • @piyushvadhel2065
      @piyushvadhel2065 Рік тому +2

      Because you are comparing 2 files but in video shows 2 sheets within the same files. Just copy paste content in Sheet2 in same file and check.

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

      ​@@piyushvadhel2065I have did what you said....but it's not working ...

  • @Rameshkumar-qc9jc
    @Rameshkumar-qc9jc Місяць тому

    Sir tall data vs 2b data kese match krte hai uska koi vidoe

  • @Newbollywoodmusicc
    @Newbollywoodmusicc 3 роки тому +2

    How to fill all missing value in sheet two from sheet one pls. Help

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

    Thanks

  • @narendersingh6346
    @narendersingh6346 2 роки тому +16

    I am not able to compare two excel sheets. Error is showing as : "You cannot use references to other worksheets or workbooks for conditional formatting criteria" Sir, please give solution.

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

    Good

  • @aadiicryptotv3002
    @aadiicryptotv3002 3 роки тому

    Sir Andriod Sheet ya Excel App mai ye kesy krnegy uska b bta dy plzz

  • @surjitsinghshairi6414
    @surjitsinghshairi6414 7 місяців тому

    Well explained however cannot see the video as it was blur

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

    Thanku

  • @jitendrapatel3897
    @jitendrapatel3897 3 роки тому

    Fine

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

    You may not use references to other worksheets or workbooks for Conditional Formatting criteria...if i am using ur said method for compare what is the solution for this

  • @lod2.097
    @lod2.097 Рік тому

    You may not reference to other for conditional formatting criteria how to solve this problem??

  • @Aribpathaan
    @Aribpathaan 3 роки тому

    It can only compare the value ??

  • @gurv4595
    @gurv4595 3 роки тому

    Bhaiya mere pas 15 sheets ki ek file hai... usme se mai ek sheet se kuch Entry delete krke kuch formatting kr ke Us sheet ko ready krta hu toh... mai Chahata hu ki Jo Maine ek seet m kaam kiyaa wo ek sath Sb m ho Jaye..???

  • @anupvpawar
    @anupvpawar 3 роки тому

    Do work on NSE Report file

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

    It data is up and down in second sheet then how can we compare..please prove the formula

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

    Sir Excel ka 2 file hai jisme name father name , mobile number toh isko match karke dekhna hai ki same log toh nahi hain dono sheet me but ek naame ke bahut log hain name and father name dono match karna hai kaise karenge

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

    i have two spared sheets one is called stock with price
    and another is called calculator
    in a stock sheet there is 3 columns category and sub category and price
    that shows in calculator sheet in list form
    i am not able to get a specific price of category and subcategory wise
    ex fruit is category and apple is sub category and 100 is price
    in calculator sheet fruit and apple are showing but how can i get the price of it
    please help me............
    looking to hear from you..

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

      साहेब या मध्ये फक्त नंबर compare होतात name nahi

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

    If the serial is not maintained than how to compare

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

    If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys

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

      I think you have to first divided that information in another cells

  • @somilgupta5123
    @somilgupta5123 7 місяців тому

    SIR YE EXCEL 2007 ME WORK NHI KRTA HAI KYA SIR OR SHEET KA RENAME CHANGE KIYE HAI KYA USSE SIR ERROR TO NHI RHA HAI NA SIR SHEET 2 REFERENCE DOES NOT EXIST KRKE SIR AISA KUCH LIKHA HUA

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

    Hi Team,
    I need solution here lets say I have 4 cloumns a,b,c,d
    I want to look for a value of a1 in entire c column if it matches then I need to print the value which is difference of b-d(d is row which matched a & c).
    Thanks in advance for helping.

  • @vijaykaushik12
    @vijaykaushik12 3 роки тому

    Windows 7 , office 2007 mai not working. Showing message - "conditional formatting not work for different sheets"

    • @EasyExplain
      @EasyExplain  3 роки тому

      Please Upgrade your office Package

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

    Dear Sir, I am not able to compare two sheets. Getting error message….There are number of guys who have mentioned that error. Please help to solve that. It’s very useful but right now we many are facing problem. Kindly help. It’s urgent

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

    You can't use references to other worksheets or workbooks for conditional formatting criteria.
    Please anyone who know how to solve this please help me

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

    On pressing F4 the $ sign is not going

  • @mamtasolanki3444
    @mamtasolanki3444 3 роки тому

    Will it be applied on name?

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

    👍

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

    감사합니다 선생님

  • @viveksharma4193
    @viveksharma4193 3 роки тому

    Jo difference wo alag sheet mein populate karne ho toh

  • @experimentgamer6524
    @experimentgamer6524 3 роки тому

    🙏👍🤗❤️

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

    Hi sir, it is showing an error of “You cannot use references to other worksheets or workbooks for Conditional Formatting criteria “
    Please guide sir about this

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

    Not working for me

  • @VijayVerma-vi7qw
    @VijayVerma-vi7qw 2 роки тому

    Nahi ho raha hai.

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

    getting an error sir

  • @Sheena-gq9ur
    @Sheena-gq9ur 9 місяців тому

    Not ise full

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

    Not working

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

    Kaam nhi kar ra

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

    I need some help regarding excel can I contact you on insta????

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

    Not working