Make One Dropdownlist , Including all table Column Cell Details Show without Dependent Dropdownlist ?

[krunal123]

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ???

How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist


************************************************NOT USE DEPENDENT DROP-DOWN LIST***********************************************************

 

[Fluff]

What is the name of your table?

 

[krunal123]

What is the name of your table?

"Table 1"

 

[Fluff]

Ok, in an empty cell put

=LET(Rng,Table1,Rws,ROWS(Rng),Seq,SEQUENCE(Rws*COLUMNS(Rng),,0),Ary,INDEX(Rng,MOD(Seq,Rws)+1,INT(Seq/Rws)+1),UNIQUE(FILTER(Ary,Ary<>"")))

and then you can refer to that cell in the data validation. So if you put the formula in G3 you would use

=G3#

in the DV.

 

[krunal123]

Ok, in an empty cell put

=LET(Rng,Table1,Rws,ROWS(Rng),Seq,SEQUENCE(Rws*COLUMNS(Rng),,0),Ary,INDEX(Rng,MOD(Seq,Rws)+1,INT(Seq/Rws)+1),UNIQUE(FILTER(Ary,Ary<>"")))

and then you can refer to that cell in the data validation. So if you put the formula in G3 you would use

=G3#

in the DV.

=LET(Rng,Table1,Rws,ROWS(Rng),Seq,SEQUENCE(Rws*COLUMNS(Rng),,0),Ary,INDEX(Rng,MOD(Seq,Rws)+1,INT(Seq/Rws)+1),UNIQUE(FILTER(Ary,Ary<>"")))


Pleased explain me this formula working in my Example ...................................

Pleased,.......

 

[Fluff]

It combines all cells into a single column by pulling each row from column 1 then from column 2 etc.
The best way to see what a formula is doing is to use the Evaluate Formula button on the formula tab.