Comparing Two List in Excel using 4 Methods!

Download All Excel Practice files Join our app : bit.ly/3vriiOb
In Excel using 4 different methods we can compare two list to each other - if you wanted to know how we can do it in excel then you must watch entire video this will be real job issues for excel users.
Timestamps
00:00 Intro - Comparing List in Excel
00:24 First Method Using If Formula
02:42 Second Method Using VLOOKUP Formula
06:14 Third Method Using COUNTIF Formula
09:57 Fourth Method Using Conditional Formatting
Download Practice file Join our app
:bit.ly/3vriiOb
---------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
---------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
---------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
---------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
---------------------------------------------------------------------------------------------------------------------------
My CZcams Gears :
Best Mic for Recording (Condenser Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

[@Excel_Tutorial]

Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
✅ Watch on Desktop : skillcourse.in/

[@user-gj5ot8ww8q]

इसी vlookup को ढूंढ रहा था।
धन्यवाद धन्यवाद धन्यवाद 💐

[@rajatraut1952]

sir khup khup धन्यवाद itka aavghd function itkya sopya shabdat shikvlya badal ❤

[@Excel_Tutorial]

Thank you so much 😀, Keep watching the new videos I am uploading.

[@rajatraut1952]

@@Excel_Tutorial yes sure 👍

[@yasirhameed8010]

Great i found what i was looking for

[@sarfealam5364]

Useful formula thank you so much sir

[@pinkiharshitphatak2934]

Useful information sir 🙏🙏🙏🙏 good 😀 morning

[@mohammadwasiuddin6579]

fantastic and Marvellous your all teachin with understanding method - Thanks Sir

[@Excel_Tutorial]

Keep watching

[@Jamalhappy]

Zabardast sir...

[@RahulKumar-ly6ly]

Thanks a lot sir

[@ayushshinde137]

Goodevening Sir bahut accha video hai thanks Sir

[@8850240]

Thanks You Sir

[@shahidshadman8028]

Very helpful video. Thank you very much.

[@Excel_Tutorial]

Glad it was helpful!

[@ronak--sinyal41119]

Great Sir Keep It Up Sir 👍🏻👍🏻👍🏻

[@soumandas459]

Very useful vdieo Sir

[@kgnkhan111]

Thanks sir
Good आइटम
☺️☺️☺️☺️

[@tariqdking]

Great way to explain

[@Excel_Tutorial]

Keep watching

[@KiranKumar-th2xy]

Nice 🙏🙏

[@ashik2954]

Thanks from Bangladesh

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@Alli21]

Awesome Sir 🔥

[@Excel_Tutorial]

Keep watching the new videos I am uploading.

[@satishcomputersportsedu.9440]

Nice

[@itzallrounder1732]

Luv from odisha

[@mominmoiz2126]

thank you

[@Excel_Tutorial]

Keep watching

[@mishaalnaseer7411]

Thank you for helping

[@Excel_Tutorial]

Keep watching

[@shreeramnirmal2139]

11:45​@@Excel_Tutorial

[@x2channel423]

Sir, if the 1st column includes duplicate values itself then conditional formatting will work?

[@advitsingh5132]

Hello Sir
are you working on programming language course (like:- Python , java ,etc)
Please tell

[@hiteshchourey9730]

Sirji, excel mai 2 columns ya usse jyada columns kese match karege

[@accountingmadeeasy8135]

Sir mujhe invoice Ka serial drag Karna jaise SI/001/08-21 tu kis tar ha kareinge

[@mr.andmrs.sharmadholpur9234]

What do if all names are random not in line

[@SunilKumar-dp4hu]

Sir Excel hang sheet ko kaise fix kare..??

[@zabivines5908]

Sir excel me gst bill kaise banaye. Plz help me 🙏

[@kskdjdjdjdjkskdjdjdj1433]

Sir MS Excel ma kuch bhe type nahi ho raha
Ctrl+w click keya or problem start ho gaye

[@vijaykaushik12]

Sir
different sheets ho to kya kare ??

[@jitendergusain4551]

Website ka name bataye please

[@vikasvk291]

Sir tally ka dusara part banaye sir

[@Somnathshinde2009]

Clear talking understand talking😊

[@Excel_Tutorial]

Keep watching

[@nabeelansari1337]

Sir complete MIS ka course kitne me hoga aur kaise kraoge aap

[@realtutorial550]

Msoffice ka course learn more app pe hai ji

[@nabeelansari1337]

@@realtutorial550 ok sir

[@pankajknowledgeworld]

Learn more.
ये तो easy program था हो गया.. इसलिए कुछ मुश्किल करके दिखाए.
1= Ek rows के पांच colom left main aur right के पांच colom से compare krke दिखाए और output थोड़ा simple हो.. Colom मे date भी हो सकता है, नंबर भी हो सकता है Text भी.. Sab ek line program से result आजाये..
2= जो output आता है वो आप लोग दोनों दिखाते हैं मैच और not मैच by color लेकिन जो match हो वो ही results आए.. बिना match वाले नहीं आए या बिना match वाले ही आए..

[@devvrattyagi9312]

2nd काम नहीं कर रहा

[@kskdjdjdjdjkskdjdjdj1433]

Jajna

[@Somnathshinde2009]

Clear talking understand talking😊

[@Excel_Tutorial]

Keep watching