Quickly Reconcile Two Tables and Highlight Differences in Excel

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

[@FaizanEGulista]

Thank you sir #Gain_it

[@marathesanjay9855]

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

[@MrPZAHOOR]

Wah Deepak Sir Kya andaz Hain apke sikhane ka.

[@mumteshkumar9830]

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

[@VishalSingh-jt7ou]

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

[@mohammedsadam5600]

Superb bhaiya

[@syedakhil1243]

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

[@bkdeshmukh12]

Very nice trick sir thanks for awesome video 👍

[@masudrahman8410]

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

[@hiramanvishwakarma4268]

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

[@alexgoommen]

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

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

[@viveksatpute3259]

Thanks sir ji good information save time while working

[@Tracks777]

lovely content

[@ravishilpi4814]

Content is superb. Thank you Brother

[@muhaamadansar5299]

Buht khoob bhai... love from pakistan

[@rosariocoutinho8690]

Very good and simple

[@Skmotivational9621]

Deepak Sir ji aap bahut achhi Tarah se samzate hai

[@ajaythakor1498]

Very helpful video sir

[@Tracks777]

nice content

[@vishnupp3200]

Super Deepak, all your videos are useful and helpful

[@LachhoLuxury]

❤❤❤Very Nice Sir❤❤❤

[@nickbell6311]

Excellent video thanks🙏

[@UmeshYadav-nw4oc]

Amazing tricks

[@Shafiudding]

Nice brother, helped a lot

[@varshapatel9635]

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

[@chirpy1381]

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

[@dileshwarisahumini4915]

👌👌👌

[@kiransati3508]

Bhut badiya sir

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

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

[@AmitPal-ek9mw]

Very nice

[@ImranAli-ow3os]

Nice video sir

[@Pankaj-Verma-]

Great video.

[@shahnazbano1929]

Very helpful 👍

[@JMrai7437]

Your instruction is great. Thanks Sir.

[@Nihalsaviation350]

Excellent tutorial.

[@khalidalisubhanallah2947]

Very knowledgeable video 👍

[@nisamansari1049]

sir aap bahut achha batate hai thanku

[@soumyabandyopadhyay6751]

You are unique boss....

[@ruchikasharma6435]

Waaao amazing 🌺🙏🌸🥰

[@childrensgyan8123]

Super Deepak Sir

[@mewaramtoliya53]

Knowage and teaching meothred corlesion is fine, I like it

[@2enslavedspirit]

Thank you Deepak, you are great :-)

[@rupeshlopes5631]

Good trick, Thanks

[@mansoorahmed2484]

Nice training.

[@vlogwithyatishkandhari6293]

Super smart ,, thanks 👍

[@kamalakarsalgaonkar4066]

very very useful

[@koushikmandal8311]

Ap great ho sir❤❤

[@inderjitsingh9717]

Very good sir

[@samiranadhikary4468]

wow lovely sir thanks

[@takashimovies6437]

Excellent sir

[@bhaveshparmar431]

Super sirji

[@narendrabadatiya2308]

Awesome sir hi 👍

[@viveksatpute3259]

Excellent

[@satyamthepassionate5430]

God 😇🙏👼 bless you Gurujii!

[@zareenalyas2355]

kzbin.info/www/bejne/mV7FqnidZdKqfKc plzzzzz sbacribe

[@hpwalikars6733]

Super,,Sir,,

[@vinaymishra8108]

Best 👌

[@indrajitchoudhury8222]

nice

[@pankajsaini50]

Thank you so much Sir...

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

[@chyarmennanda]

Thank you so much for this VDO

[@psthakursingh8707]

Super sir ji

[@virendertanwer9562]

Good sir...

[@muhammadshakir4625]

Zabardast

[@Ravindra31sd]

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

[@DeepakEduWorld]

Coming soon

[@SanviPatil2019]

nice video

[@GovindSharma-cr2vb]

Thanks for this Video

[@deepamanmappy]

Awesome

[@prabhakarpawar573]

Very usefull व्हिडिओ sir

[@DeepakEduWorld]

After long time.. i m reading your comment 🥰

[@pradeepnegi7523]

Nice sir

[@dastageera9626]

Thank you brother for great infermation!!!

[@bijaykumarmishra7689]

Good morning Deepak sir

[@theinformerworld]

Very nice sir ji.

[@neerajdhawan3565]

Super sir

[@premkhadka7120]

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

[@DeepakEduWorld]

Asap 👍

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

[@imranakbar7463]

Nice

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

[@Barneedhar]

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 👍

[@abukawcher3843]

thanks

[@bhanurajput8939]

Nyc

[@asimsiddiq475]

v.good.

[@bebright9052]

superb

[@innovativelearning8212]

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

[@SKumar-ut9vp]

Thank you sir

[@MantuYadavYM]

👌👌

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

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

[@imrankazmi7101]

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

[@rajatvvij4841]

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

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

[@mibrahimmeo]

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

[@SANTOSHKUMAR-nb1cc]

Thanks sir

[@shawarjun719]

Thanx,,..

[@raj0936]

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

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

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

[@RohitSingh-nu7ek]

You can compare with help of pivot table.

[@shivamjaiswal4090]

Kya ye chz text me ho skti h?

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

[@UdayKumarMoon]

We can do it by vlookup also adding iferror formula.