INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel

INDIRECT Dependent Dynamic Drop Down List | How to create Dynamic Drop-Down List in Excel

Innozant

3 года назад

63,304 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@deekshaagrawal6105
@deekshaagrawal6105 - 26.11.2020 18:16

Just saw add while watching your video where that girl was giving job to those, who have lost their jobs due to covid
I must say you are doing the same thing even better bcoz you are making people job ready ... Thank you so much for very valuable training...👍

Ответить
@DIPGGG
@DIPGGG - 28.12.2023 05:21

How to display common data from more than 5 lists whose column header is in a drop down menu

Ответить
@chandrasekharchakrabarty8860
@chandrasekharchakrabarty8860 - 04.12.2023 06:19

Hats off to your teaching style. I love teaching (though I am not a teacher), but really love and like the way you explain the topics. Salute. - CS Chakrabarty, Mumbai.

Ответить
@aldoseba
@aldoseba - 01.10.2023 19:00

Should change the title and add "in hindi" so people who don't understand don't waste their time with this.

Ответить
@RahulRoy-po9ct
@RahulRoy-po9ct - 20.08.2023 17:39

🙏 SIR

Ответить
@praveenkumar-jk4rm
@praveenkumar-jk4rm - 30.06.2023 09:40

Sir drop down list me agar particular selection ke alawa all data kaise select Karen plz discribe

Ответить
@Monusingh-xi4vc
@Monusingh-xi4vc - 22.06.2023 16:10

Not Working Sir

Ответить
@motivationalshayarisneha1210
@motivationalshayarisneha1210 - 28.04.2023 14:43

Sir aap kaise underscore hain maine books ke name copy paste kr ke fir ek ek kr ke underscore dale toh drop down list me page number nhi aaya fir aapne jo underscore dale hin ussy ki toh list aa gya

Ответить
@rudingeorge
@rudingeorge - 21.03.2023 04:48

Very useful video....❤

Ответить
@umerkayani79
@umerkayani79 - 10.03.2023 11:09

Thanks Sir
How to freez format of one cell, where we put in column, date n then dropdown change to value but value not changed...🧐

Ответить
@patternsdadar5610
@patternsdadar5610 - 02.12.2022 18:18

Sir in this video on 10.32 you have shown how to populate list in the cells instead of drop down list. I tried doing the same but I'm getting value error inspite of doing Ctrl + Enter. Can you help me out on this issue.

Ответить
@kashirmirza6483
@kashirmirza6483 - 06.09.2022 12:23

How to combine two rows in data validation list?

Ответить
@shrikantbadge3978
@shrikantbadge3978 - 31.07.2022 06:45

Ye sach me bohot powerful video hai sir. THanks

Ответить
@shrikantbadge3978
@shrikantbadge3978 - 31.07.2022 06:40

Very powerful video sir.

Ответить
@shrikantbadge3978
@shrikantbadge3978 - 31.07.2022 06:40

Very powerful video sir. Thank you.

Ответить
@rajnarayan1739
@rajnarayan1739 - 27.06.2022 16:34

Dynamic Drop Down List with auto refresh like first we chose county then auto refresh the state and block list.. please sir help me

Ответить
@irfandaud7380
@irfandaud7380 - 17.05.2022 12:03

Great Video

Ответить
@hirenpatel3621
@hirenpatel3621 - 16.05.2022 13:33

Excellent sirji 👍🏻👍🏻👍🏻👍🏻

Ответить
@maryrosediaz7313
@maryrosediaz7313 - 15.05.2022 13:22

I am working in my spreadsheet and lost the data validation formula this video suites what am looking for yet the language huhuhu please make one with subtitles 🥺

Ответить
@aptrends3257
@aptrends3257 - 27.03.2022 20:06

Thank You Very Much Sir

Ответить
@simrankapoor6397
@simrankapoor6397 - 09.03.2022 16:46

Very nice 👌

Ответить
@neeshusingh5908
@neeshusingh5908 - 03.02.2022 08:09

Sir Aapne ye naming range me _ kese liya h because me jab validation laga rha hu to _ ke sath to error aa rha hai (aThe source currently evaluates to an error.) Please help 🙏

Ответить
@bachchuhaldar3783
@bachchuhaldar3783 - 13.11.2021 00:42

Great video.... ❤️❤️❤️ Sir I have a question...I have name list in another sheet... How to drop down list another sheet....?

Ответить
@chetan1008
@chetan1008 - 24.10.2021 11:08

👍👍👍

Ответить
@paramjeet975singh3
@paramjeet975singh3 - 01.10.2021 12:50

Sir jab mai indirect se list highlight kar raha hu ctlrl + shift + enter se... Tab value to aa rahi hai magar jaha blank cell hai uski jagah 0 show kar raha hai.....

Aur agar mai ctlr + enter use karta hu to
Aadhi adhuri value aa raha hai?

Ответить
@RajuSingh-df8hv
@RajuSingh-df8hv - 13.09.2021 18:39

I am confused that how it bring the list we made through IF, it can take the list from box given in question or what if we made the another list with same book name, does it take from that range as well. Sir, can you please make me understood the logic its worked to considering the list.

Ответить
@GarryChahalOFFICIAL
@GarryChahalOFFICIAL - 29.08.2021 12:23

The Source currently evaluates to an error. Do you want to continue का error आ रहा है भाई किया क्रू 😭

Ответить
@thankikamalkumar9841
@thankikamalkumar9841 - 25.08.2021 14:00

Drop Down works fine when both options are available within same sheet, however when it is available in separate sheets then don't work?

Ответить
@lassinianshinifunnyvlogs1215
@lassinianshinifunnyvlogs1215 - 12.08.2021 12:00

Many thanks for your trainings, very helpful

Ответить
@meenur1982
@meenur1982 - 02.08.2021 19:54

Sir How can i download the Excel file

Ответить
@sachinkumarsachin9687
@sachinkumarsachin9687 - 27.07.2021 07:38

Hi sit
What is the shortcut key to Row Height and Coloum width in office 365

Ответить
@shonakmdheeraj7590
@shonakmdheeraj7590 - 25.07.2021 21:42

Dear sir your videos are really awesome please keep it up effort and please make video on automatically vendor reconciliation also

Ответить
@tanmoy151
@tanmoy151 - 24.07.2021 08:07

KINDLY HELP ME I CANT APPLY INDIRECT (CELL ID) FORMULA

Ответить
@AmitChandra_YouTube
@AmitChandra_YouTube - 19.07.2021 09:42

Thank you Sir for this video.
I have a different problem, requesting for help.
One Coloum (A) having Names,
Next coloum (B) indicate Male or Female. And it is growing by the time.
I need a dorpdown list in column C on Names only for males.
How it could be done ? Please help .

Ответить
@gauravbanerjee7891
@gauravbanerjee7891 - 19.07.2021 07:48

Sir bahut interesting tha..

Ответить
@Radhe.mahant2010
@Radhe.mahant2010 - 15.07.2021 19:32

Indirect is not working in two workbook properly

Ответить
@mushtaqali267
@mushtaqali267 - 05.07.2021 15:14

Janab ye jo vdo may ap nazr arahay hain is per bhee vdo bana dain

Ответить
@sanjitpaul2953
@sanjitpaul2953 - 04.07.2021 08:41

Great Sir. You have made INDIRECT function very useful to me. Thank you.

Ответить
@johndas8173
@johndas8173 - 07.06.2021 10:05

Sir forcast formula ka video ka aayega sumifs sumproduct edate financial formula gst formula ke sath

Ответить
@asmrindia
@asmrindia - 05.06.2021 23:27

Great

Ответить
@PopatMomu
@PopatMomu - 22.05.2021 08:19

Bahot khoob

Ответить
@garudzeputkarshakade2697
@garudzeputkarshakade2697 - 19.05.2021 16:58

सर आप बहुत हि अच्छा सिखाते हो अगर कोई सवाल मेरे मन आता है तो उसका जवाब मुझे आपके विडीओ देखकर मिलता है .Thank you so much sir.

Ответить
@KamalSingh-yt5rr
@KamalSingh-yt5rr - 11.05.2021 21:28

Just a great video !!! Enjoyed myself to learn something new thru this video.

I've a question for you regarding drop down list. Suppose if I want to populate more than one item name in one particular cell using drop down...can you please help me out with this?

It would be really helpful 🙏

Ответить
@jaiyadav1256
@jaiyadav1256 - 31.03.2021 20:51

Excellent

Ответить