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

[@nalinikantadash8669]

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

[@NikhiSingh-rj7oq]

Thank you so much ,very usefull and working

[@maboodahmad7289]

Thank you its working❤

[@EasyExplain]

Welcome 👍

[@nileshphalke1516]

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

[@soumendupahari4232]

Very good sir and useful

[@swetapaul209]

Thanks bro it worked.

[@rishabhgupta5460]

Thanks bro it worked

[@RamSharma-Talks]

Well explained👍

[@Bhardwajvijay28]

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

[@EasyExplain]

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

[@swatichauhan4835]

Which Excel version u r using ?😊

[@mann23800]

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

[@AMITKUMAR-qx3zk]

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

[@0001-k2j]

Thanks 👍 information & download practice Link 🖇️🔗

[@EasyExplain]

Link given in Video description.

[@MIMGURU]

Very useful video,

[@EasyExplain]

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

[@laveshghadi2200]

Thanks a lot sir jee

[@EasyExplain]

Your Welcome. Keep Sharing.

[@UpendraSingh-my4xq]

Very informative

[@EasyExplain]

Glad it was helpful!

[@vikramshinde3622]

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

[@halalsharesstockexchange278]

Well done sir

[@Fammu7979]

Thanks

[@faroukhpoacha1]

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]

Yes mine also

[@piyushvadhel2065]

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]

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

[@pks0620]

Very useful 👌👍👍👍

[@EasyExplain]

Yes.

[@junaidzakir9864]

Osmmm👌

[@EasyExplain]

Keep Sharing 🔃♥️

[@mdkalim863]

Thanku

[@gurv4595]

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..???

[@EasyExplain]

Power Query.

[@aadiicryptotv3002]

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

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

[@narendersingh6346]

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.

[@shwetathakur3898]

same problem with me

[@sagarchaudhari2642]

Same issue

[@huneergupta80]

Same issue facing

[@chitranshshrivastava5436]

Same issue

[@vakalapudiharshasairam880]

Same problem with me

[@UpendraSingh-my4xq]

Nice video keep it up brother

[@EasyExplain]

I will try my best

[@compliancedekho1948]

Very interesting and informative!!

[@EasyExplain]

Glad you enjoyed it

[@Funnyment1990]

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

[@kss2066]

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

[@EasyExplain]

More to come!

[@jitendrapatel3897]

Fine

[@uday1616]

Good

[@EasyExplain]

Thanks

[@shishupaulbamotra1]

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

[@Newbollywoodmusicc]

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

[@surjitsinghshairi6414]

Well explained however cannot see the video as it was blur

[@lod2.097]

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

[@thekingofrealty5994]

👍

[@artfun7907]

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]

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

[@studypoint6073]

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]

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

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

[@cricophobiya4178]

=IF(COUNTIF(C:C,A1)>0,"found","not found")

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

[@pure_n84r99]

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

[@somilgupta5123]

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

[@anupvpawar]

Do work on NSE Report file

[@EasyExplain]

Like?

[@Aribpathaan]

It can only compare the value ??

[@EasyExplain]

Cells

[@vijaykaushik12]

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

[@EasyExplain]

Please Upgrade your office Package

[@sachi17007]

If the serial is not maintained than how to compare

[@mamtasolanki3444]

Will it be applied on name?

[@EasyExplain]

Whatever written in cells

[@mehtabrahim6259]

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

[@vvn2718]

감사합니다 선생님

[@experimentgamer6524]

🙏👍🤗❤️

[@EasyExplain]

❤👌👍

[@abhishekthayya5428]

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]

Not working for me

[@viveksharma4193]

Jo difference wo alag sheet mein populate karne ho toh

[@mihirmehta8402]

On pressing F4 the $ sign is not going

[@swarnarajvaidhya6394]

Same issue

[@poojarani-qh4ez]

Same issue ..

[@faroukhpoacha1]

getting an error sir

[@VijayVerma-vi7qw]

Nahi ho raha hai.

[@navyasree7280]

Not working

[@Sheena-gq9ur]

Not ise full

[@samarbisht5350]

Kaam nhi kar ra

[@NaveenGamingOfficial]

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

[@rajugoud1563]

Not working