Data Validation in Excel | Drop-down lists | FREE Excel Course

[@manishsoni1652]

I must say that you have provided a very good excel course for free. Generally, people don't do that. Thanks a lot

[@ellisiverdavid7978]

A wise man once said: "𝑻𝒂𝒍𝒌𝒊𝒏𝒈 𝒂𝒃𝒐𝒖𝒕 𝒊𝒕 𝒅𝒐𝒆𝒔 𝒏𝒐𝒕 𝒎𝒂𝒌𝒆 𝒔𝒐 𝒎𝒖𝒄𝒉 𝒔𝒆𝒏𝒔𝒆 𝒂𝒔 𝒔𝒉𝒐𝒘𝒊𝒏𝒈 𝒊𝒕." - Bansal, S. (2014, 17:44) And this profound truth applies to thesis defense presentations, job screenings, promises of "change for the better", "I'll pay you later", and in love and relationships! 😂 Almost everything manifests a clearer sense when there's "more than words" to prove things. Simply brilliant ✨

[@jimbim1623]

Wow you really took that to heart huh

[@IndikaSugathapala]

Wowwwww...because You'r a real Teacher, i should say truly '''never seen a man like you before... true logic (not joking really )

[@pabitrakumarrout1101]

You are a gifted teacher.

[@wayneedmondson1065]

Hi Sumit.. great lesson and review of Data Validation tips and techniques. Thanks for sharing this video series.. very helpful. Thumbs up!

[@praveenrajarapu7121]

Thank you so much sumith you have explained crystal and clear way..

[@rmalhotra925]

Excellent Sir. Bless you.

[@prashantkumar4887]

You can simply make a dynamic drop down list just by selecting extended range and by allowing ignore blank cells. simple, and it works the same

[@iliesboukhatem7803]

very useful tutorial, thank you so much !

[@riddhipatel6771]

You are a saviour 😍😍

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@samipiyash9322]

great tutorial

[@MOHAMMADASEFHOSSAINIMSC]

Excellent work, thank you so much sir.

[@GoGetSP]

29:42, you discussed the same and it gave an error, why if OFFSET formula giving 2011? thanks Sumit, watching you from Brazil.

[@shaimakhan5682]

Quite informative stuff!

[@couragetamakloe4621]

Thank you, Sumit. I really enjoy your lessons. How do I stop Excel from flashfilling when I use an offset formula? For example, when I use this formula (=OFFSET($O$8,0,0,COUNTIF($O$8:$O$17,""&"")) Excel flashfills all the bottom rolls. I turned off automatic flashfill but I'm still getting the same results.

[@acoustical.ly_]

you are realllly goooood .

[@mostafa4321]

Excellent work thank yu

[@kirandeepchoudhry9232]

Nice video Trump bro, Can you please make video on income tax calculation for assessment year 2019-20.

[@balwinderlal9444]

You should explain more brief about formulas in excel ur recent excel formula videos needs more clarification....

[@monicahasija8036]

Can we make dynamic drop-down by using index function?

[@guldaar16_58]

Yes, refer to Video 17. Last 5 mins

[@amolpathak199]

You are doing a great job..but by going into too deep by mixing several formulas confuses the beginner level student.

[@FRANKWHITE1996]

thanks!

[@heeyaboruah9226]

Does anyone find it odd I am in grade 7, 12 years old, going through school stress yet learning another thing, Excel, and learning excel formulas, trying to find a job for excel after I finish next month but all this just for the knowledge and fun of knowing about how to so called learn about the "hardest thing to learn"? Well I do...

[@yash9625]

Hope you do well!!! CHEERS

[@briannaspeezy4258]

Its better to be learning it a 12 years old than 52 years old.

[@viscaelbarca6279]

I didn't get what you have done after 20th minute, I mean not complaining just didn't understand.

[@GoGetSP]

at 30:35, when I am using List as Validation Criteria I am able to do Data Validation but with Custom as Validation Criteria , it's not happening? why is that?

[@GoGetSP]

AT 5:18, 12345 LEN = 5? THEN WHY RESTRICTED?

[@trumpexcel]

Because the condition I put was minimum of 10 and maximum of 15. So it won't allow me to enter anything where the length is less than 10 or more than 15

[@GoGetSP]

@@trumpexcel misread it as 1 , thanks!