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.com/open?id=1B2z...
#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 KZbin 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

[@mumteshkumar9830]

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

[@marathesanjay9855]

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

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

[@bkdeshmukh12]

Very nice trick sir thanks for awesome video 👍

[@MrPZAHOOR]

Wah Deepak Sir Kya andaz Hain apke sikhane ka.

[@AmitPal-ek9mw]

Very nice

[@VishalSingh-jt7ou]

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

[@ajaythakor1498]

Very helpful video sir

[@rosariocoutinho8690]

Very good and simple

[@muhaamadansar5299]

Buht khoob bhai... love from pakistan

[@hiramanvishwakarma4268]

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

[@Skmotivational9621]

Deepak Sir ji aap bahut achhi Tarah se samzate hai

[@syedakhil1243]

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

[@Shafiudding]

Nice brother, helped a lot

[@mohammedsadam5600]

Superb bhaiya

[@masudrahman8410]

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

[@alexgoommen]

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

[@nisamansari1049]

sir aap bahut achha batate hai thanku

[@nickbell6311]

Excellent video thanks🙏

[@toprider12345]

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

[@UmeshYadav-nw4oc]

Amazing tricks

[@ImranAli-ow3os]

Nice video sir

[@bhaveshparmar431]

Super sirji

[@ra___zz]

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

[@viveksatpute3259]

Thanks sir ji good information save time while working

[@Tracks777]

lovely content

[@Tracks777]

nice content

[@Pankaj-Verma-]

Great video.

[@ravishilpi4814]

Content is superb. Thank you Brother

[@JMrai7437]

Your instruction is great. Thanks Sir.

[@kamalakarsalgaonkar4066]

very very useful

[@Ravindra31sd]

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

[@DeepakEduWorld]

Coming soon

[@user-jv8og9qt1t]

❤❤❤Very Nice Sir❤❤❤

[@SanviPatil2019]

nice video

[@GovindSharma-cr2vb]

Thanks for this Video

[@Nihalsaviation350]

Excellent tutorial.

[@samiranadhikary4468]

wow lovely sir thanks

[@inderjitsingh9717]

Very good sir

[@soumyabandyopadhyay6751]

You are unique boss....

[@vishnupp3200]

Super Deepak, all your videos are useful and helpful

[@dastageera9626]

Thank you brother for great infermation!!!

[@viveksatpute3259]

Excellent

[@abukawcher3843]

thanks

[@2enslavedspirit]

Thank you Deepak, you are great :-)

[@varshapatel9635]

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

[@mewaramtoliya53]

Knowage and teaching meothred corlesion is fine, I like it

[@hpwalikars6733]

Super,,Sir,,

[@koushikmandal8311]

Ap great ho 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"

[@kiransati3508]

Bhut badiya sir

[@khalidalisubhanallah2947]

Very knowledgeable video 👍

[@ruchikasharma6435]

Waaao amazing 🌺🙏🌸🥰

[@narendrabadatiya2308]

Awesome sir hi 👍

[@mansoorahmed2484]

Nice training.

[@vlogwithyatishkandhari6293]

Super smart ,, thanks 👍

[@pradeepnegi7523]

Nice sir

[@shahnazbano1929]

Very helpful 👍

[@chirpy1381]

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

[@dileshwarisahumini4915]

👌👌👌

[@pankajsaini50]

Thank you so much Sir...

[@imranakbar7463]

Nice

[@rupeshlopes5631]

Good trick, Thanks

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

[@virendertanwer9562]

Good sir...

[@vinaymishra8108]

Best 👌

[@chyarmennanda]

Thank you so much for this VDO

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

[@theinformerworld]

Very nice sir ji.

[@childrensgyan8123]

Super Deepak Sir

[@psthakursingh8707]

Super sir ji

[@takashimovies6437]

Excellent sir

[@asimsiddiq475]

v.good.

[@bijaykumarmishra7689]

Good morning Deepak sir

[@SUNNYKUMAR-kx3qu]

Thanks sir

[@bhanurajput8939]

Nyc

[@indrajitchoudhury8222]

nice

[@muhammadshakir4625]

Zabardast

[@deepamanmappy]

Awesome

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

kzbin.info/www/bejne/mnzCYoCbgpx_d5o

[@vidyakulkarni7720]

@@DeepakEduWorld thank u very much

[@vidyakulkarni7720]

thanks

[@raj0936]

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

[@shawarjun719]

Thanx,,..

[@MantuYadavYM]

👌👌

[@bebright9052]

superb

[@theyashraj6905]

Sir data ko table format se kaise hataye

[@satyamthepassionate5430]

God 😇🙏👼 bless you Gurujii!

[@zareenalyas2355]

kzbin.info/www/bejne/mV7FqnidZdKqfKc plzzzzz sbacribe

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

[@prabhakarpawar573]

Very usefull व्हिडिओ sir

[@DeepakEduWorld]

After long time.. i m reading your comment 🥰

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

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

[@RohitSingh-nu7ek]

You can compare with help of pivot table.

[@rajatvvij4841]

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

[@premkhadka7120]

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

[@DeepakEduWorld]

Asap 👍

[@neerajdhawan3565]

Super sir

[@AnandGautam9901]

Index se bhi ho jayega

[@thandabantu9347]

Sir mje invoice m searchable dropdown list bnani h pr Jo invoice h use protection lagai v h qk bahot s formula h waha to mje koi aysa tarika batayn I m protection sheet p searchable list laga sako

[@kannanmassey5783]

Deepak ji if we want to compare contents of all columns then helper column should contain range of column then f4, rangeb of column to compare. Kindly guide

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

[@prashantkumarparmanu]

गुरु जी , क्या ऑर्डर ID की जगह text name रहे तब भी ये formula काम करेगा क्या ?

[@shivamjaiswal4090]

Kya ye chz text me ho skti h?

[@innovativelearning8212]

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

[@UdayKumarMoon]

We can do it by vlookup also adding iferror formula.