Very simple and easy that many people make it complex....Thank you!
@TEKNISHA Жыл бұрын
Glad it was helpful!
@JP-hg5pi4 жыл бұрын
Clear, simple and quick. Thank you very much! So much better than the microsoft instructions!
@TEKNISHA4 жыл бұрын
Glad it helped!
@prakashsathyapriya2 жыл бұрын
Crisp without unwanted stories. You rocks
@christianjr3760 Жыл бұрын
Thank you very much my brother, this is what I have wanted to know since a month ago. 🙏🏾🙏🏾🙏🏾
@golddiamond67824 жыл бұрын
And finally it was the $ thing which was not allowing copying in the multiple cells.Thanks for sorting that out
@jintalaban1195 ай бұрын
Thank you very much Sir, very well explained and uncomplicated...
@gabrielnogales44073 жыл бұрын
OMG greatest solution ever... just look the other solutions over there for this same problem... you couldnt be more efficient! u made my day :)
@TEKNISHA3 жыл бұрын
Glad that this solution helped you. I have also made another version. You can check that too. kzbin.info/www/bejne/rqHLaKqoprNrh7s
@TVSCDN2 жыл бұрын
Thanks for your simple uncomplicated explanations... ❤️❤️❤️
@swathimothe267224 күн бұрын
Thank u buddy..its very use ful
@rollingthunder45992 жыл бұрын
Liked your video, just what I was looking for.
@TEKNISHA2 жыл бұрын
Glad that this Helped
@chiragLakhmani11 ай бұрын
TO THE POINT EXPLINATION , REALLY HELPFULL . TYSM
@mohanlhamsaraj40532 жыл бұрын
Super quick explanation with systematic approach...
@LabTechNajmal Жыл бұрын
I am watching after 5 years of upload, thanks. It's useful
@hvsmanian89482 жыл бұрын
I learnt from your KZbin channel. Great. Good Teaching. This is the easy way.
@mwendasilumesii96495 жыл бұрын
Wow!!! Sorted out like 90% of the problem I had, now the second column upon changing the first one.
@jonaking3203Ай бұрын
Thanks for this. Very helpful.
@jerrymilesmiles93132 жыл бұрын
Outstanding! Hi from Limón, Costa Rica!
@TEKNISHA2 жыл бұрын
Glad that you liked it
@josephdiingmajok75212 жыл бұрын
Short but extremely helpful, thanks a lot.
@TEKNISHA2 жыл бұрын
Glad that this helped you
@vickyvikneswari39562 жыл бұрын
Thank you! I managed to create the dependent list in excel :D
@TEKNISHA2 жыл бұрын
Awesome. Happy that this helped
@shrikrushnajadhav26212 жыл бұрын
I was confused for not getting dependent dropdown correctly, and you just tell exact reason of removing $ from column and cell number. Thank you.
@kianasteph_2 жыл бұрын
Thank you so much! It was exactly what I need it.
@TEKNISHA2 жыл бұрын
Glad that you liked it
@larsonfredrick24703 жыл бұрын
Excellent ! Short & sweet and to the point.
@TEKNISHA3 жыл бұрын
Thank you
@foodkpk5719 Жыл бұрын
Sooo nice my dear. very simple thank you so much. you are a nice teacherrrrr
@thebmusproject4 жыл бұрын
Nice one! Thanks!
@TEKNISHA4 жыл бұрын
You bet!
@chinnababu86732 жыл бұрын
I watched many videos but this is great ...
@Xandonezz2 жыл бұрын
thank you! you solve my problem!
@TEKNISHA2 жыл бұрын
Great. Glad that this helped
@rishipradhan36333 жыл бұрын
Thank you Sir, video was really very helpful & easy to understand
@TEKNISHA3 жыл бұрын
Glad it was of help
@gloria7708 ай бұрын
You are the best. Thank you.
@TEKNISHA5 ай бұрын
Happy to help!
@surajitpradhan3032 Жыл бұрын
Thanks for it. It's working soo good.
@TEKNISHA Жыл бұрын
You are welcome
@fiyafathima83529 күн бұрын
Thank you ❤
@thebaldguytv13403 жыл бұрын
great video! Direct to the point and very clear. Thank you!
@TEKNISHA3 жыл бұрын
Glad that this Tutorial helped you
@m.mukhtiarali60633 ай бұрын
it is so much easy. i really liked it.
@ouzz_zz10 ай бұрын
thats a good yet not much a sufficent application. you could use the Indirect with Match, Char and CountA to set the range of the second combobox.
@josemiguel2611 Жыл бұрын
Straight to the point. thank you !
@RUNNAIFY2 жыл бұрын
very quick and clear,tq Sir
@dyandraap Жыл бұрын
easy to learn, thankyou Mr. Teknisha~
@mspraveen50 Жыл бұрын
Thanks you did it simple to explain. How to remove the blank in drop down? Instead of offset
@Temprelaxe115 жыл бұрын
Nice video, Good speed and time management. Crisp and clear...Thank you
@TEKNISHA5 жыл бұрын
Thank you...
@mazharkhadri5408 Жыл бұрын
Thank you so much for demonstrating the simplest way of doing this. Much appreciated. Keep up the good work 👏.
@TValexTav4 ай бұрын
Thank you, your information was very helpful, although I encountered some difficulties with titles containing multiple words (which I resolved by inserting underscores "_" between the words).
@dadathelegend6 жыл бұрын
Thanks Buddy the video is very much useful for my exam purpose
@rinleak5712 Жыл бұрын
Thank you so so much for this video
@malamala98812 жыл бұрын
Nice 😊👏👍teaching sir, tq for your support.
@sudhakarjain12992 жыл бұрын
Very simple explanation. Useful to me.
@lakhbirsingh70092 жыл бұрын
Short & excellent
@wamzfuna24522 жыл бұрын
I love this it is very applicable
@TEKNISHA2 жыл бұрын
Happy that this helped you
@eddieftw3 жыл бұрын
Brilliant! Thank you.
@TEKNISHA3 жыл бұрын
Glad that it helped
@naboulsikhalid77634 жыл бұрын
Great video, I need this tutorial for a personal project. Thank you
@Nicecomputertutorial2 ай бұрын
Excellent bro
@pankajgupta94263 жыл бұрын
Very helpful 👍 🙂
@TEKNISHA3 жыл бұрын
Glad that this was helpful
@sachinkishore41155 жыл бұрын
Thank you bro. It is working.
@rajanphadke92732 жыл бұрын
Thanks a lot
@TEKNISHA2 жыл бұрын
Glad that this helped
@ronnelmacompas16472 ай бұрын
Thank you
@jayantmarathe9100 Жыл бұрын
Excellent👍👍👍
@TEKNISHA Жыл бұрын
thanks...
@TheGiorgioSol11 ай бұрын
Very very good!
@kch30195 жыл бұрын
Thanks for putting this up
@TEKNISHA4 жыл бұрын
You are Welcome
@hiren1980able4 жыл бұрын
Thanks for sharing.
@TEKNISHA4 жыл бұрын
Thanks for watching.. Hiren Patel
@alvinfren67906 жыл бұрын
thank you so much for your video & it does help me alot
@sherko9652 жыл бұрын
amazing, excellent job
@abhijitraul940 Жыл бұрын
Thank you so much sir...
@richardkwan28405 ай бұрын
Can you please searchable dropdown list that works for version 2019 or older
@afiartandcraft12193 ай бұрын
Thanks
@thebesttechnical36085 жыл бұрын
Supper explanation and very helpful
@harshitagupta93702 жыл бұрын
Thank you so much
@JimmiSTRATMAN4 жыл бұрын
Very good video, didn't beat around the bush but quick & easy with good instruction. thanks for sharing & will subscribe to your channel
@TEKNISHA4 жыл бұрын
Thank you jim
@h.ktraders29283 жыл бұрын
Thanks Brother
@TEKNISHA3 жыл бұрын
Happy that this helped...
@ristab5678 Жыл бұрын
❤thank you very much. 🎉
@ksyamsundar11119 күн бұрын
Superb
@shaik.khamer14752 жыл бұрын
Thanks Sir
@techdunia6558 Жыл бұрын
Thankyou
@ankitpathak36952 жыл бұрын
Really thanks 👍🙏
@Islamiclibrary1285 ай бұрын
Thanks...
@TEKNISHA5 ай бұрын
You're welcome!
@armieAHMAD Жыл бұрын
thank you so much.
@arifkadir7456 Жыл бұрын
thanks
@anhnhatnguyet46282 жыл бұрын
A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?
@curlyrapunzel3380 Жыл бұрын
Yes, it can be done. You have to highlight the preferred column where you want the data validation to occur and apply the data validation in the column. E.g if you want the data validation to have effect in column D, you need to highlight the whole of column D and apply the data validation
@nadirazizaziz8172 Жыл бұрын
I like your information video. Send me more info. Thank you
@vaseemkhan3856Ай бұрын
How to put price break up chart for jewellery website in discription column for each product also if possible it should be linked with next coloumns values dynamically in excel.
@remoteflying3 жыл бұрын
Great video, other channels drag this on for 18 minutes. What if the first drop down had names with spaces? Like 'Green fruits" and "Orange fruits"? Named ranges cannot have spaces
@TEKNISHA3 жыл бұрын
Thank you George. Check my updated video for the multiple dependent drop-down list. In this method you can use names with spaces. kzbin.info/www/bejne/rqHLaKqoprNrh7s
@juliayeo8122 жыл бұрын
Thank you for the video! It definitely helped however I would like to know if I am able to select the 1st level and have the 2nd level automatically inserted on the 2nd level instead of having it as a drop down? Which means once I select the 1st level, I do not need to type out the 2nd level as I only have single text to display. 😊
@TEKNISHA2 жыл бұрын
Glad that you liked it. Yes it is possible to pull the 2nd level text. For this you need to use a lookup method like index/match or vlookup. All your first level and respective 2nd level information needs to be in a table and then you can use a lookup method to populate the 2nd level based on the 1st level chosen
@juliayeo8122 жыл бұрын
@@TEKNISHA oh no, I have not done those you mentioned before... I'm clueless! Can tou shed some advice here... thank you so much!!
@valerianovello7038 Жыл бұрын
THANKS FOR THAT VIDEO! PS: Für Dummies wie mich: Formel wenn Excel auf Deutsch ist = Indirekt :D
@JamesJones-uk7zs7 жыл бұрын
Nice video, but the method of adding blank cells to the range in case of additional values is sloppy and doesn't presentation t well. instead make the named range dynamic by using an OFFSET formula and COUNTA
@jaychikhalkar23512 жыл бұрын
Thanks sir u r great
@CharlieChopstixTV Жыл бұрын
Very useful
@ZAHEERKHAN-km9nv2 жыл бұрын
Nice
@TEKNISHA2 жыл бұрын
Glad that you liked it
@iatfvijayan43602 жыл бұрын
Thank
@shakeeratadeoye657811 ай бұрын
Very easy to understand but I have a problem with the indirect function the other day I wanted to do it, it was saying there is a problem with the formula so I was thinking maybe it's the version of my Excel
@3dpowercontracting4452 жыл бұрын
Thank you for the this video. How can i put the color automatically once i choose particular type? 😊
@mtfvks2 жыл бұрын
Super Sir
@TEKNISHA2 жыл бұрын
Glad that this helped
@82chandar Жыл бұрын
Hi, Instead of dependent drop dow, can we get both fruit & vegetables in same list under names using expand & collapse. Eg: Fruit-> expand -> names & Vegetables -> names
@bernardobenvegnupasinatto7090 Жыл бұрын
There’s a better way to do it without blank rows. But your video helped a lot
@jonobugs5 жыл бұрын
Maybe I'm doing something wrong, but this list doesn't seem to be dynamic. Rather it seems to look at the cell you type for indirect for. So, that means the first one will be fruit and the second will be vegetables even if you select fruit again.
@jeffreybean54662 жыл бұрын
Encountered the same issue.
@mohammedashrafak1900 Жыл бұрын
Perfect!
@Νίκοςλιακο2 жыл бұрын
Thanks for the Video. Also i want to ask you something in case that i have make an error with the selection of second list , how i could change the selection which created at first?
@growwithus97102 жыл бұрын
Plz make same video for google sheet
@intoqalbunahmad17313 жыл бұрын
Really need your help
@bobbymartins7349 Жыл бұрын
Hi Nice Simple Vid but just to let u know I had issue going forward after removing both the $$ symbols, its only after I kept the 1st $ Symbol before ColumnG and removed the 2nd $symbol, i was able to proceed
@susmitadas35354 жыл бұрын
Nice dada
@TEKNISHA4 жыл бұрын
Thank you Susmita
@jayanaidu76673 жыл бұрын
Thanks for the video What if I have to chose only 3 options out of 5 in the drop down skipping a cell. Example 1 3 and 5 how do I do it