Pull Dynamic List

[smurr13]

Hey folks, hoping someone can help with the following - I am trying to create a custom list that is dynamic in length based on the criteria from a master table. See example below of what I'm trying to do. Let me know if this is unclear/need more info. Thanks!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[smurr13]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

365 - sorry about that!

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B	C	D	E	F	G
1
2		1	2	3	4	5	6
3		2	2	3	3	6	6
4
5
6		1
7		1
8		2
9		2
10		3
11		3
12		3
13		4
14		4
15		4
16		5
17		5
18		5
19		5
20		5
21		5
22		6
23		6
24		6
25		6
26		6
27		6
Sheet6

Cell Formulas
Range	Formula
B6:B27	B6	=TOCOL(IF(SEQUENCE(MAX(B3:G3))<=B3:G3,B2:G2,1/0),2,1)
Dynamic array formulas.

 

[smurr13]

Legend - thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.