Quickly Reconcile Two Tables and Highlight Differences in Excel

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

[@karthikrajgopal8627]

Super ji..
May God bless u..
Stay humble like this always.. Keep sharing ur knowledge..
U ll definitely reach to the top..

[@DeepakEduWorld]

🥰♥️

[@nikhilabhishek802]

Very well said,so nice and consistent effort,really appreciated 😊👍

[@mdfaizanhere]

Thank you sir
#Gain_it

[@marathesanjay9855]

Super sirji
Aap ke video se hame Bahut kuchh sikhane milta he

[@bkdeshmukh12]

Very nice trick sir thanks for awesome video 👍

[@VishalSingh-jt7ou]

The best video.. I was literally looking this kind of video and finally I got it.. thank you so much

[@mumteshkumar9830]

Super sir, बहुत बेहतरीन

[@alexgoommen]

This was so valuable, Many Thanks, a very helpful and time-saving

[@masudrahman8410]

Thank you Deepak bi your lesson helps me a lot and keep it up

[@MrPZAHOOR]

Wah Deepak Sir Kya andaz Hain apke sikhane ka.

[@syedakhil1243]

Deepak really so nice and easy.
Thank you so much for gave easy method.

[@viveksatpute3259]

Thanks sir ji good information save time while working

[@ajaythakor1498]

Very helpful video sir

[@siddesham7531]

my one major problem resolved, before this i use to check with vlookup now this made my work easy
thank u very much

[@DeepakEduWorld]

🥰

[@SIMRANKAUR-eg7nc]

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"

[@nisamansari1049]

sir
aap bahut achha batate hai
thanku

[@hiramanvishwakarma4268]

Yhi mai jab se find kr rha tha finally mila thankyou ❤

[@rosariocoutinho8690]

Very good and simple

[@Skmotivational9621]

Deepak Sir ji aap bahut achhi Tarah se samzate hai

[@AmitPal-ek9mw]

Very nice

[@abukawcher3843]

thanks

[@Tracks777]

lovely content

[@nickbell6311]

Excellent video thanks🙏

[@Ravindra31sd]

nice video sir excel ka full complicit course video banaiye sir please

[@DeepakEduWorld]

Coming soon

[@mewaramtoliya53]

Knowage and teaching meothred corlesion is fine, I like it

[@toprider12345]

Deepak bhai Allah ap ko salamat rakhay, kamal ki cheez hy Thanks.

[@ra___zz]

Thank you so much sir mera bohot bada tension khatam ho jata gya 🎉❤

[@codewithss]

Koi itna achha kaise pada sakta hai sir bahut achha padate hai ek bar me hi samjh aa jata hai sir thank you sir

[@Shafiudding]

Nice brother, helped a lot

[@ravishilpi4814]

Content is superb. Thank you Brother

[@Tracks777]

nice content

[@SanviPatil2019]

nice video

[@GovindSharma-cr2vb]

Thanks for this Video

[@amitmishra1513]

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

[@UmeshYadav-nw4oc]

Amazing tricks

[@samiranadhikary4468]

wow lovely sir thanks

[@JMrai7437]

Your instruction is great. Thanks Sir.

[@Nihalsaviation350]

Excellent tutorial.

[@muhaamadansar5299]

Buht khoob bhai... love from pakistan

[@chirpy1381]

Hello Deepk. I am really thankful to for a Macro recording video. It really reduced the repetitive steps.

[@dileshwarisahumini4915]

👌👌👌

[@innovativelearning8212]

For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....

[@kamalakarsalgaonkar4066]

very very useful

[@varshapatel9635]

Very usefull .it helped me a lot.. thank u

[@vishnupp3200]

Super Deepak, all your videos are useful and helpful

[@Pankaj-Verma-]

Great video.

[@bhaveshparmar431]

Super sirji

[@mohammedsadam5600]

Superb bhaiya

[@soumyabandyopadhyay6751]

You are unique boss....

[@ImranAli-ow3os]

Nice video sir

[@user-jv8og9qt1t]

❤❤❤Very Nice Sir❤❤❤

[@inderjitsingh9717]

Very good sir

[@pankajsaini50]

Thank you so much Sir...

[@SureshSingh-fb1hj]

Bhai ji conditional formating se order id ko duplicate karke 1 minuye me ho jayega.

[@DeepakEduWorld]

Nahi hoga....

[@SureshSingh-fb1hj]

Dono table me order id ko select karlo coditional formating me duplicate kar lo fir colour kar lo bari bari dono table me

[@vidyakulkarni6100]

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.

[@DeepakEduWorld]

ruclips.net/video/dK_1MeM7LA8/видео.html

[@vidyakulkarni7720]

@@DeepakEduWorld thank u very much

[@vidyakulkarni7720]

thanks

[@2enslavedspirit]

Thank you Deepak, you are great :-)

[@vlogwithyatishkandhari6293]

Super smart ,, thanks 👍

[@khalidalisubhanallah2947]

Very knowledgeable video 👍

[@Jogendrasinghjat]

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

[@DeepakEduWorld]

Asap 👍

[@viveksatpute3259]

Excellent

[@ruchikasharma6435]

Waaao amazing 🌺🙏🌸🥰

[@SUNNYKUMAR-kx3qu]

Thanks sir

[@koushikmandal8311]

Ap great ho sir❤❤

[@rupeshlopes5631]

Good trick, Thanks

[@RohitSingh-nu7ek]

You can compare with help of pivot table.

[@chyarmennanda]

Thank you so much for this VDO

[@shabarilucky5]

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

[@TheBarneedhar]

One idea you could explore would be concatenating order ID and amount in another cell and follow the trick suggested in this video.

[@DeepakEduWorld]

please wait .. i ll publish another video shortly on this topic 👍

[@narendrabadatiya2308]

Awesome sir hi 👍

[@hpwalikars6733]

Super,,Sir,,

[@mansoorahmed2484]

Nice training.

[@satyamthepassionate5430]

God 😇🙏👼 bless you Gurujii!

[@zareenalyas2355]

ruclips.net/video/c-byEg0mwFE/видео.html plzzzzz sbacribe

[@shahnazbano1929]

Very helpful 👍

[@kiransati3508]

Bhut badiya sir

[@bijaykumarmishra7689]

Good morning Deepak sir

[@theinformerworld]

Very nice sir ji.

[@premkhadka7120]

WOW! Excellent! Can you please make a video how can be reconcile more than 2 tables?

[@DeepakEduWorld]

Asap 👍

[@imranakbar7463]

Nice

[@dastageera9626]

Thank you brother for great infermation!!!

[@takashimovies6437]

Excellent sir

[@childrensgyan8123]

Super Deepak Sir

[@raj0936]

Compare tavi hoga jb dono left sabse left honge...ya bich me data rahe to v compare ho sakta hai

[@muhammadshakir4625]

Zabardast

[@pradeepnegi7523]

Nice sir

[@asimsiddiq475]

v.good.

[@SKumar-ut9vp]

Thank you sir

[@virendertanwer9562]

Good sir...

[@UdayKumarMoon]

We can do it by vlookup also adding iferror formula.

[@vinaymishra8108]

Best 👌

[@psthakursingh8707]

Super sir ji

[@shawarjun719]

Thanx,,..

[@ussinmer]

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

[@hv3300]

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?

[@DeepakEduWorld]

Ys... You can hide helper column

[@saurabhdixit3283]

Sir mai daily production report banata hu
But ek sheet ka closing 2nd sheet ke opening me transfer nhi hota hai
Please suggestions de

[@indrajitchoudhury8222]

nice

[@prabhakarpawar573]

Very usefull व्हिडिओ sir

[@DeepakEduWorld]

After long time.. i m reading your comment 🥰

[@bhanurajput8939]

Nyc

[@mibrahimmeo]

I have excel function problem.. How to ask you about it...

[@imrankazmi7101]

I'm trying to use conditional formatting as you guided but 0 and 1 number also convert in red color. Please guide me

[@bebright9052]

superb

[@deepamanmappy]

Awesome

[@rajatvvij4841]

Sir really liked ur video but if we have to compare two parameters instead of just one parameter pls sugget

[@neerajdhawan3565]

Super sir

[@rims1104]

Match ka function bhi use kar sakte hai aur uske saath IF ke sath ISNUMBER ka function use karenge.

[@thunderboygaming5128]

Instead of Count If we can also you V lookup and then data validation

[@chandankedia5797]

This formula helps to reconcile gst r2a with book

[@Patel.Darshan]

With the help if vlookup nd Pivot table