Comparing Two List in Excel using 4 Methods!

  Рет қаралды 78,373

Excel Tutorial

2 жыл бұрын

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: ✅
www.youtube.com/@realtutorial550
Complete Technology:✅
www.youtube.com/@CompleteTechnology
Learn more shorts:✅
www.youtube.com/@LearnMoreShorts
Satish Tech (Marathi):✅
www.youtube.com/@Satish_Tech
Tally Tutorial:✅
www.youtube.com/@TallyTutorial
Excel Tutorial:✅
www.youtube.com/@Excel_Tutorial
Learn More:✅
www.youtube.com/@Learn_More
Curiosity: ✅
www.youtube.com/@curiosity9432
---------------------------------------------------------------------------------------------------------------------------
My KZbin 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

Пікірлер: 52
@Excel_Tutorial
@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
@user-gj5ot8ww8q 15 күн бұрын
इसी vlookup को ढूंढ रहा था। धन्यवाद धन्यवाद धन्यवाद 💐
@Jamalhappy
@Jamalhappy 2 күн бұрын
Zabardast sir...
@shahidshadman8028
@shahidshadman8028 Ай бұрын
Very helpful video. Thank you very much.
@Excel_Tutorial
@Excel_Tutorial 23 күн бұрын
Glad it was helpful!
@pinkiharshitphatak2934
@pinkiharshitphatak2934 2 жыл бұрын
Useful information sir 🙏🙏🙏🙏 good 😀 morning
@ayushshinde137
@ayushshinde137 2 жыл бұрын
Goodevening Sir bahut accha video hai thanks Sir
@kgnkhan111
@kgnkhan111 2 жыл бұрын
Thanks sir Good आइटम ☺️☺️☺️☺️
@sarfealam5364
@sarfealam5364 10 ай бұрын
Useful formula thank you so much sir
@yasirhameed8010
@yasirhameed8010 Жыл бұрын
Great i found what i was looking for
@ashik2954
@ashik2954 4 ай бұрын
Thanks from Bangladesh
@RahulKumar-ly6ly
@RahulKumar-ly6ly 2 жыл бұрын
Thanks a lot sir
@mohammadwasiuddin6579
@mohammadwasiuddin6579 4 ай бұрын
fantastic and Marvellous your all teachin with understanding method - Thanks Sir
@Excel_Tutorial
@Excel_Tutorial 7 күн бұрын
Keep watching
@8850240
@8850240 2 жыл бұрын
Thanks You Sir
@ronak--sinyal41119
@ronak--sinyal41119 2 жыл бұрын
Great Sir Keep It Up Sir 👍🏻👍🏻👍🏻
@soumandas459
@soumandas459 2 жыл бұрын
Very useful vdieo Sir
@x2channel423
@x2channel423 4 ай бұрын
Sir, if the 1st column includes duplicate values itself then conditional formatting will work?
@mr.andmrs.sharmadholpur9234
@mr.andmrs.sharmadholpur9234 2 ай бұрын
What do if all names are random not in line
@itzallrounder1732
@itzallrounder1732 2 жыл бұрын
Luv from odisha
@tariqdking
@tariqdking 10 ай бұрын
Great way to explain
@Excel_Tutorial
@Excel_Tutorial 4 күн бұрын
Keep watching
@KiranKumar-th2xy
@KiranKumar-th2xy 8 ай бұрын
Nice 🙏🙏
@advitsingh5132
@advitsingh5132 2 жыл бұрын
Hello Sir are you working on programming language course (like:- Python , java ,etc) Please tell
@mishaalnaseer7411
@mishaalnaseer7411 7 ай бұрын
Thank you for helping
@Excel_Tutorial
@Excel_Tutorial 7 күн бұрын
Keep watching
@shreeramnirmal2139
@shreeramnirmal2139 Күн бұрын
11:45​@@Excel_Tutorial
@hiteshchourey9730
@hiteshchourey9730 2 жыл бұрын
Sirji, excel mai 2 columns ya usse jyada columns kese match karege
@accountingmadeeasy8135
@accountingmadeeasy8135 2 жыл бұрын
Sir mujhe invoice Ka serial drag Karna jaise SI/001/08-21 tu kis tar ha kareinge
@satishcomputersportsedu.9440
@satishcomputersportsedu.9440 2 жыл бұрын
Nice
@pankajknowledgeworld
@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 वाले ही आए..
@SunilKumar-dp4hu
@SunilKumar-dp4hu 8 ай бұрын
Sir Excel hang sheet ko kaise fix kare..??
@Alli21
@Alli21 Жыл бұрын
Awesome Sir 🔥
@Excel_Tutorial
@Excel_Tutorial 2 күн бұрын
Keep watching the new videos I am uploading.
@kskdjdjdjdjkskdjdjdj1433
@kskdjdjdjdjkskdjdjdj1433 2 жыл бұрын
Sir MS Excel ma kuch bhe type nahi ho raha Ctrl+w click keya or problem start ho gaye
@mominmoiz2126
@mominmoiz2126 7 ай бұрын
thank you
@Excel_Tutorial
@Excel_Tutorial 7 күн бұрын
Keep watching
@jitendergusain4551
@jitendergusain4551 8 ай бұрын
Website ka name bataye please
@zabivines5908
@zabivines5908 2 жыл бұрын
Sir excel me gst bill kaise banaye. Plz help me 🙏
@vikasvk291
@vikasvk291 2 жыл бұрын
Sir tally ka dusara part banaye sir
@vijaykaushik12
@vijaykaushik12 2 жыл бұрын
Sir different sheets ho to kya kare ??
@psporte9621
@psporte9621 2 жыл бұрын
Sir List 1 Products Hai Aur list 2 Product Discount Dena Hain to Kaise krenge .....? L1 L2 Google - 5% KZbin - 7% Yahhoo - 10% Google - 5% ......…... Agar koi Vedio Ho to Link Share Kre Please
@devvrattyagi9312
@devvrattyagi9312 Жыл бұрын
2nd काम नहीं कर रहा
@nabeelansari1337
@nabeelansari1337 2 жыл бұрын
Sir complete MIS ka course kitne me hoga aur kaise kraoge aap
@realtutorial550
@realtutorial550 2 жыл бұрын
Msoffice ka course learn more app pe hai ji
@nabeelansari1337
@nabeelansari1337 2 жыл бұрын
@@realtutorial550 ok sir
@Somnathshinde2009
@Somnathshinde2009 3 ай бұрын
Clear talking understand talking😊
@Excel_Tutorial
@Excel_Tutorial 7 күн бұрын
Keep watching
@kskdjdjdjdjkskdjdjdj1433
@kskdjdjdjdjkskdjdjdj1433 2 жыл бұрын
Jajna
@samratdutta6213
@samratdutta6213 2 ай бұрын
Don't do unnecessary Comedy
@Somnathshinde2009
@Somnathshinde2009 3 ай бұрын
Clear talking understand talking😊
@Excel_Tutorial
@Excel_Tutorial 7 күн бұрын
Keep watching