Quickly Reconcile Two Tables and Highlight Differences in Excel
HTML-код
- Опубликовано: 6 сен 2024
- in this video we will show you how to compare two tables in excel and highlight the differences using countif formula. you can quickly reconcile two tables and highlight differences in excel
How do you compare two Excel sheets and highlight the difference?
How do you compare two lists in Excel and pull matching data?
How do I compare two tables in Excel for differences?
Download Training File drive.google.c...
#exceltutorial
#exceltips
#excelformula
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe to Deepak EduWorld ► / deepakeduworld
Follow on Instagram ► / deepak__nehra
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We always provide useful & helpful content on the Deepak EduWorld RUclips channel, here MS Excel tips and tricks, and tips and tricks for MS Word, and Internet tips and tricks, along with the computer related Useful Information Simple language available in Hindi You can visit our channel playlist's. It is our effort to get this information useful for all types of Excel users, ms word users, computer users and internet users.
Tags: quickly reconcile two tables and highlight differences in excel,microsoft excel,conditional formatting,how to,microsoft excel (software),excel tricks,excel tutorial,deepak eduworld,data reconciliation,compare two columns in excel,excel,microsoft excel tutorial 10 minutes school,microsoft excel tutorial
Super ji..
May God bless u..
Stay humble like this always.. Keep sharing ur knowledge..
U ll definitely reach to the top..
🥰♥️
Very well said,so nice and consistent effort,really appreciated 😊👍
Thank you sir
#Gain_it
Super sirji
Aap ke video se hame Bahut kuchh sikhane milta he
Very nice trick sir thanks for awesome video 👍
The best video.. I was literally looking this kind of video and finally I got it.. thank you so much
Super sir, बहुत बेहतरीन
This was so valuable, Many Thanks, a very helpful and time-saving
Thank you Deepak bi your lesson helps me a lot and keep it up
Wah Deepak Sir Kya andaz Hain apke sikhane ka.
Deepak really so nice and easy.
Thank you so much for gave easy method.
Thanks sir ji good information save time while working
Very helpful video sir
my one major problem resolved, before this i use to check with vlookup now this made my work easy
thank u very much
🥰
Yeah it's a good video. But I believe some more testing situations should be Demonstrated. I recommend watching A video on channel "off to office"
sir
aap bahut achha batate hai
thanku
Yhi mai jab se find kr rha tha finally mila thankyou ❤
Very good and simple
Deepak Sir ji aap bahut achhi Tarah se samzate hai
Very nice
thanks
lovely content
Excellent video thanks🙏
nice video sir excel ka full complicit course video banaiye sir please
Coming soon
Knowage and teaching meothred corlesion is fine, I like it
Deepak bhai Allah ap ko salamat rakhay, kamal ki cheez hy Thanks.
Thank you so much sir mera bohot bada tension khatam ho jata gya 🎉❤
Koi itna achha kaise pada sakta hai sir bahut achha padate hai ek bar me hi samjh aa jata hai sir thank you sir
Nice brother, helped a lot
Content is superb. Thank you Brother
nice content
nice video
Thanks for this Video
Hi, nice explanation!!!
We have 2 Student tables with same columns name, check the both table columns based on roll no if the cell value not matched highlights the cells
Eg 2 tables are ther with multiple columns Qty, price and amount and if table 1 Qty, price OR amount any value is not matched with table 2 columns based on order I'd then it will highlight cell
Amazing tricks
wow lovely sir thanks
Your instruction is great. Thanks Sir.
Excellent tutorial.
Buht khoob bhai... love from pakistan
Hello Deepk. I am really thankful to for a Macro recording video. It really reduced the repetitive steps.
👌👌👌
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
very very useful
Very usefull .it helped me a lot.. thank u
Super Deepak, all your videos are useful and helpful
Great video.
Super sirji
Superb bhaiya
You are unique boss....
Nice video sir
❤❤❤Very Nice Sir❤❤❤
Very good sir
Thank you so much Sir...
Bhai ji conditional formating se order id ko duplicate karke 1 minuye me ho jayega.
Nahi hoga....
Dono table me order id ko select karlo coditional formating me duplicate kar lo fir colour kar lo bari bari dono table me
s aapke videos very helpful hai thank you for giving such vedios. sir website se data copy karke excel me kaise paste karna hai wo bhi bataiye please sir.
ruclips.net/video/dK_1MeM7LA8/видео.html
@@DeepakEduWorld thank u very much
thanks
Thank you Deepak, you are great :-)
Super smart ,, thanks 👍
Very knowledgeable video 👍
Sir, micro pe ek esaa video banao jo 1 sheet se dusri sheet pe data 5 minute me apne app copy hota rahe |
Please make one video
Asap 👍
Excellent
Waaao amazing 🌺🙏🌸🥰
Thanks sir
Ap great ho sir❤❤
Good trick, Thanks
You can compare with help of pivot table.
Thank you so much for this VDO
Thanks for teaching new technique.
What we want to reconcile with multiple fields. Like order number and amt can we have any source to do so
One idea you could explore would be concatenating order ID and amount in another cell and follow the trick suggested in this video.
please wait .. i ll publish another video shortly on this topic 👍
Awesome sir hi 👍
Super,,Sir,,
Nice training.
God 😇🙏👼 bless you Gurujii!
ruclips.net/video/c-byEg0mwFE/видео.html plzzzzz sbacribe
Very helpful 👍
Bhut badiya sir
Good morning Deepak sir
Very nice sir ji.
WOW! Excellent! Can you please make a video how can be reconcile more than 2 tables?
Asap 👍
Nice
Thank you brother for great infermation!!!
Excellent sir
Super Deepak Sir
Compare tavi hoga jb dono left sabse left honge...ya bich me data rahe to v compare ho sakta hai
Zabardast
Nice sir
v.good.
Thank you sir
Good sir...
We can do it by vlookup also adding iferror formula.
Best 👌
Super sir ji
Thanx,,..
Hello can you please help me when I am trying to lock cell by pressing F4 cell won't be lock but another window is open
Great work. If I delete helper column after using it will this stop reconciliation? or in other words I need to keep this helper column and the only way it is not seen by others it to "Hide" it?
Ys... You can hide helper column
Sir mai daily production report banata hu
But ek sheet ka closing 2nd sheet ke opening me transfer nhi hota hai
Please suggestions de
nice
Very usefull व्हिडिओ sir
After long time.. i m reading your comment 🥰
Nyc
I have excel function problem.. How to ask you about it...
I'm trying to use conditional formatting as you guided but 0 and 1 number also convert in red color. Please guide me
superb
Awesome
Sir really liked ur video but if we have to compare two parameters instead of just one parameter pls sugget
Super sir
Match ka function bhi use kar sakte hai aur uske saath IF ke sath ISNUMBER ka function use karenge.
Instead of Count If we can also you V lookup and then data validation
This formula helps to reconcile gst r2a with book
With the help if vlookup nd Pivot table