Create a list that automatically sorts data (alphabetically) in excel using Countif and Index Match

  Рет қаралды 11,640

Innozant

Innozant

Күн бұрын

Пікірлер: 65
@ManishVerma-gg8xl
@ManishVerma-gg8xl 3 жыл бұрын
सर बार बार इस tricks को देखा और सिखा और सर एक बात ये tricks के बारे मे पहले से नही पता थी । 🙏🙏🙏
@tejpalsain1507
@tejpalsain1507 4 жыл бұрын
बहुत बढ़िया ट्रिक सर जी। मजा आ गया। Thank you
@Innozant
@Innozant 4 жыл бұрын
Thanks Tejpal.. Happy Learning
@tejpalsain1507
@tejpalsain1507 4 жыл бұрын
Happy teacher's day sir jee.
@satishojha6240
@satishojha6240 4 жыл бұрын
Happy teacher day sir you are the best excel teacher.Good night sir
@Innozant
@Innozant 4 жыл бұрын
Thanks..Satish..God bless you.
@jaishrisaxena1083
@jaishrisaxena1083 4 жыл бұрын
Happy teachers day to my (Awesome Teacher) Dilip ji !! God aap jaise teacher banye , too subka future bright ho Jaye.
@Innozant
@Innozant 4 жыл бұрын
Thanks Jaishri,God bless you dear,Even m happy to have the career oriented dedicated learner like you.Have a wonderful career ahead.
@khizar6664
@khizar6664 2 жыл бұрын
Thanks sir because of this I have solved my big problem, extract Unique items with sort A to Z, Excel 2016
@Innozant
@Innozant 2 жыл бұрын
Thanks.Happg Learning ❤️
@kishorpanara4191
@kishorpanara4191 4 жыл бұрын
Wish you many many happy returns of the day my favorite teacher
@Innozant
@Innozant 4 жыл бұрын
Thanks Kishor ,God Bless you dear
@sams4948
@sams4948 2 жыл бұрын
Very very helpful thanks
@naeemkhan-tm9hx
@naeemkhan-tm9hx 4 жыл бұрын
Something new and unique as usual...happy teacher day
@Innozant
@Innozant 4 жыл бұрын
Thanks Naeem sahab..God bless you dear
@bhoopendraraghav9781
@bhoopendraraghav9781 4 жыл бұрын
Happy teacher's day sir...
@Innozant
@Innozant 4 жыл бұрын
Thanks Bhoopi..God bless you
@bhoopendraraghav9781
@bhoopendraraghav9781 4 жыл бұрын
@@Innozant welcome sir
@puransingh-sx2tk
@puransingh-sx2tk 4 жыл бұрын
Happy teacher's day sir
@Innozant
@Innozant 4 жыл бұрын
Thanks Puran
@sandeepaswal8944
@sandeepaswal8944 4 жыл бұрын
Sir, The lecture was very helpful. I learnt a lot about excel. Really hats off sir ..Thank you so much sir.I respect you so much! Happy Teachers' Day Sir.
@Innozant
@Innozant 4 жыл бұрын
Thanks Sandeep,God Bless you dear.
@bishtlokesh1297
@bishtlokesh1297 4 жыл бұрын
Happy teacher day sir
@Innozant
@Innozant 4 жыл бұрын
Thy Lokesh,God Bless You dear
@vikassinghjayara510
@vikassinghjayara510 4 жыл бұрын
Happy Teacher's Day Dilip Sir
@Innozant
@Innozant 4 жыл бұрын
Thanks Vicky..God Bless You..
@rjraviraftarup7553
@rjraviraftarup7553 4 жыл бұрын
Happy teachers day 🙏🙏🙏
@Innozant
@Innozant 4 жыл бұрын
Thankw Ravi,.God bless you dear
@Soft-tips-tricks
@Soft-tips-tricks 4 жыл бұрын
Happy Teachers Day sir
@Innozant
@Innozant 4 жыл бұрын
Thanks God Bless you dear
@shrikantbadge3978
@shrikantbadge3978 4 жыл бұрын
आपके हर व्हिडिओ मे छप्पर फाड के knowledge hai Sir. I have been watching excel videos on you tube since a year now. I have found that they extend a video for too long explaining a simple topic while you give away ample of knowledge in short duration with precise explanation. Thanks.
@Innozant
@Innozant 4 жыл бұрын
Thanks Shrikant for such a lovely feedback, Really close to my heart. Love you Brother.🙏❤️Have a blooming career ahead.
@BalvirSingh-qs9kz
@BalvirSingh-qs9kz 3 жыл бұрын
Sir, very nice.
@Innozant
@Innozant 3 жыл бұрын
Thanks Balvir Ji
@mohanpal13555
@mohanpal13555 2 жыл бұрын
Great vedio
@ishutiwari5567
@ishutiwari5567 4 жыл бұрын
it is very useful sir thanks a lot 🙏
@Innozant
@Innozant 4 жыл бұрын
Thanks Ishu for your valuable comment.Really means a lot to me. We welcome you to the Innozant family,Experience the taste of success with Innozant-Seed of Success.🙏❤️
@sarvodayaconventvidisha1757
@sarvodayaconventvidisha1757 2 жыл бұрын
वाह जनाब
@spatelprinting496
@spatelprinting496 3 жыл бұрын
Thank You
@Innozant
@Innozant 3 жыл бұрын
Thanks
@paramjeet975singh3
@paramjeet975singh3 3 жыл бұрын
Decending order Mai bhi ho sakta hai kya sir
@shadab0104
@shadab0104 2 жыл бұрын
I think,you should try with ">" instead of "
@puransingh-sx2tk
@puransingh-sx2tk 4 жыл бұрын
Sir vedio ko publish karne k sath sath agar vedio ko series number de de to sequence main dekhne main or revise Krna easy hoga. Baki sab acha hai
@Innozant
@Innozant 4 жыл бұрын
Puran yadi aaap Playlist wise video dekhenge to saare video in sequence hain..Jaise Aap Basic Excel Ke Playlist ko hi dekhiye ek baar aapko saare video jaise class hota hai usi sequence me milenge..phir bhi main Numbering bhi kar deta hu
@Innozant
@Innozant 4 жыл бұрын
Dear Puran..Ab Channel ke home screen par hi aap dekh sakte hain playlist Videos in a Sequence-Basic To adv Excel playlist step by step seekhiye usi sequence mein
@rjraviraftarup7553
@rjraviraftarup7553 4 жыл бұрын
Super
@arunkumarsinghark3024
@arunkumarsinghark3024 2 жыл бұрын
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@MonirHossain-xe5ud
@MonirHossain-xe5ud Жыл бұрын
hello sir, it's Monir from Bangladesh who is a very eager student & fan. but i have a problem that once you are showing examples, you are using different columns. is it possible to create same in one cell? would be happy & appreciate your response pls 🙏
@xixi2693
@xixi2693 3 жыл бұрын
Sir in excel sheet i want cell B(old)=B(old)+A(new) in cell A data is coming form website in real time cell B i want to retain its old data and go on adding new data from cell A ,in same cell B
@gauravbhatia7987
@gauravbhatia7987 4 жыл бұрын
Thnq sir
@subhaschandramandal4430
@subhaschandramandal4430 2 жыл бұрын
Sir, Kindly share the sorting automatically how to sort the date of joining based on date of birth who is older than others employees i.e. create seniority list.
@infovibes2537
@infovibes2537 4 жыл бұрын
Help me sir..i am searching for the job of MIS executive from three weeks and i got only 2 interview calls.. and they said they will call..but I didn't not get response Help me in how to search for the job of MIS And interview faciing learning from u only
@Innozant
@Innozant 4 жыл бұрын
Hi Amresh Kindly rate yourself out of 10 in knowledge of Excel,Share your CV with us ,You need to go for our Skill achiever assessment test ,We provide Interview calls to skilled candidate.
@sandcl2007
@sandcl2007 3 жыл бұрын
Can you please tell me which file should I download for this topic & from where?
@Innozant
@Innozant 3 жыл бұрын
Assignment master folder link are there.i am working on direct link
@ubaidillahmuhammad20
@ubaidillahmuhammad20 4 жыл бұрын
link file download : 404. That’s an error.
@Innozant
@Innozant 4 жыл бұрын
Recheck it's perfectly fine..you may download file from any video link.. common link for all file
@srinivasgoudmanthapuri2719
@srinivasgoudmanthapuri2719 3 жыл бұрын
🙏
@rabikantverma9770
@rabikantverma9770 2 жыл бұрын
SIR DATA TO SORT HO GYA .,.PAR SAMASYA REH GYI......SALE REPORT BANATEY HAIN TAAB SAKE VALUE LENE KE LIYE VLOOOK LAGANA PADTA HAI WAHAN SAME NAME PE VLOOKUP KAAM HI NAHI KARTA
@owaisullah9297
@owaisullah9297 2 жыл бұрын
Create a data automatically sort date wise oldest to newest
@shadab0104
@shadab0104 2 жыл бұрын
Dear Sir, hope, It will also work with date, not an issue, only need to convert result column in date format. Thanks
@TurUwU
@TurUwU 2 жыл бұрын
I wish the dislike button worked. Really tired of these "full English titles, desc but speaking party English.
@riyadalela6096
@riyadalela6096 4 жыл бұрын
Happy teacher's day sir..
@Innozant
@Innozant 4 жыл бұрын
Thanks Riya
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
EXCEL HACKS useful Tricks You Must Know
13:01
Innozant
Рет қаралды 13 М.
The ULTIMATE Index Match Tutorial (5 Real-World Examples)
11:53
Kenji Explains
Рет қаралды 221 М.
INDEX MATCH Excel Tutorial
15:29
Kevin Stratvert
Рет қаралды 435 М.
Conditional Rank Formula using COUNTIFS - Custom RANKIF Function
5:36
How To Automatically Sort Data When New data is entered in Excel
11:12
Deepak EduWorld
Рет қаралды 51 М.
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 148 МЛН