How To Compare Two Excel Sheets in Hindi | Compare Excel Sheets For Differences | Excel in Hindi
HTML-код
- Опубликовано: 16 авг 2021
- How To Compare Two Excel Sheets in Hindi | Compare Sheets in Excel | Excel Sheet Comparison | Excel
In This video we will learn how to compare two excel sheets in excel in Hindi. We will learn comparing excel sheets by using Conditional Formatting and creating new rules for comparison. It is going to be a very easy and Fast tutorial on Comparing excel sheets in simple and easy language.
#Excel #Trending #EasyExplain
Download Practice File Here: docs.google.com/spreadsheets/...
Very nice. I like it. It's useful.
धन्यवाद साहेब तुमचे खुप खुप आभार 🙏🙏
Thanks bro it worked.
Thank you so much ,very usefull and working
Thanks bro it worked
Very nice and thank you. Sir can we compare two work book data? Plz tell me!!
Well explained👍
Very interesting and informative!!
Glad you enjoyed it
Well done sir
Thanks
Very useful 👌👍👍👍
Yes.
good lesson! would love to learn more excel lessons from your channel
More to come!
Thank you its working❤
Welcome 👍
Very useful video,
You're Welcome. Keep Sharing 🔃♥️👍🏻
Fine
Very informative
Glad it was helpful!
감사합니다 선생님
Kya hum 2 data sheet me se capital or small laterr ko bhi highlight kr skte h
Thanks a lot sir jee
Your Welcome. Keep Sharing.
Nice video keep it up brother
I will try my best
Thanks 👍 information & download practice Link 🖇️🔗
Link given in Video description.
How to fill all missing value in sheet two from sheet one pls. Help
This vedio is very useful. Can we compare more than two sheets?
Yes. But in third sheet you have to apply conditional formatting again
Which Excel version u r using ?😊
Osmmm👌
Keep Sharing 🔃♥️
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
Sir Andriod Sheet ya Excel App mai ye kesy krnegy uska b bta dy plzz
Good
Thanks
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
You may not reference to other for conditional formatting criteria how to solve this problem??
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.
=IF(COUNTIF(C:C,A1)>0,"found","not found")
Well explained however cannot see the video as it was blur
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
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"
Yes mine also
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.
@@piyushvadhel2065I have did what you said....but it's not working ...
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
I think you have to first divided that information in another cells
🙏👍🤗❤️
❤👌👍
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..
साहेब या मध्ये फक्त नंबर compare होतात name nahi
It can only compare the value ??
Cells
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..???
Power Query.
If the serial is not maintained than how to compare
Do work on NSE Report file
Like?
It data is up and down in second sheet then how can we compare..please prove the formula
Windows 7 , office 2007 mai not working. Showing message - "conditional formatting not work for different sheets"
Please Upgrade your office Package
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
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.
same problem with me
Same issue
Same issue facing
Same issue
Same problem with me
Its not working in office 2010
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
Jo difference wo alag sheet mein populate karne ho toh
Will it be applied on name?
Whatever written in cells
Not working for me
On pressing F4 the $ sign is not going
Same issue
getting an error sir
Nahi ho raha hai.
Not ise full
Not working
Kaam nhi kar ra
I need some help regarding excel can I contact you on insta????
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
Not working