Can I make the data validation dropdown list expand to show more choices?

[MrBadEXCEL]

I have several data validation dropdown lists [not combo boxes from the developer tab] that have more than 12 items in them.
Is it possible to edit the list's format so they display more items in the list when the dropdown is clicked?

 

[ravi2628]

Hi,

I have Tried This Logic Can you Please check if Possible

the filter will change Dynamically

Book1
	G	H	I	J	K	L	M
1					Drop Down List
2	2018	Yellow	2018 Yellow		0		2018 Yellow
3	2018	Blue	2018 Blue		2018 Yellow
4	2018	Red	2018 Red		2018 Blue
5	2018	Yellow	2018 Yellow		2018 Red
6	2018	Blue	2018 Blue		2017 Yellow
7	2018	Red	2018 Red		2017 Blue
8	2018	Yellow	2018 Yellow		2017 Red
9	2018	Blue	2018 Blue		2017 Green
10	2018	Red	2018 Red		2017 Violet
11	2017	Yellow	2017 Yellow		2017 Pink
12	2017	Blue	2017 Blue
13	2017	Red	2017 Red
14	2017	Green	2017 Green
15	2017	Violet	2017 Violet
16	2017	Red	2017 Red
17	2017	Yellow	2017 Yellow
18	2017	Blue	2017 Blue
19	2017	Red	2017 Red
20	2017	Pink	2017 Pink
Mapping Data

Cell Formulas
Range	Formula
K2:K11	K2	=UNIQUE(I:I,0,0)
I2:I20	I2	=CONCATENATE(G2," ",H2)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
M2	List	=$K$2:$K$19

Data Validation List selected till highlighted Range.



View attachment 44908

I Have forget you are using 2016 version right so i have change the Unique list Drop List Logic for you.

Book1
	G	H	I	J	K	L	M
1					Drop Down List
2	2018	Yellow	2018 Yellow		2018 Yellow		2018 Yellow
3	2018	Blue	2018 Blue		2018 Blue
4	2018	Red	2018 Red		2018 Red
5	2018	Yellow	2018 Yellow		2017 Yellow
6	2018	Blue	2018 Blue		2017 Blue
7	2018	Red	2018 Red		2017 Green
8	2018	Yellow	2018 Yellow		2017 Violet
9	2018	Blue	2018 Blue		2017 Red
10	2018	Red	2018 Red		2017 Pink
11	2017	Yellow	2017 Yellow
12	2017	Blue	2017 Blue
13	2017	Green	2017 Green
14	2017	Green	2017 Green
15	2017	Violet	2017 Violet
16	2017	Red	2017 Red
17	2017	Yellow	2017 Yellow
18	2017	Green	2017 Green
19	2017	Red	2017 Red
20	2017	Pink	2017 Pink
Mapping Data

Cell Formulas
Range	Formula
I2:I20	I2	=CONCATENATE(G2," ",H2)
K2:K20	K2	=IFERROR(INDEX($I$2:$I$20,MATCH(0,COUNTIF($K$1:K1,$I$2:$I$20),0)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Cells with Data Validation
Cell	Allow	Criteria
M2	List	=$K$2:$K$19