Dynamically list values based on user input

[TINA31415]

I have a list of 10,000 different values in a pivot table. Based on a number a user enters, perhaps 20, I want to populate a list of the first 20 values from my pivot table. I need this to be dynamic because perhaps one user may want to see 10 values, but another user may want to see 50.

I included an example of what I'm looking for below.

 

[FormR]

Hi, if you have the SEQUENCE() function available - you can try.

=INDEX($A$3:$A$10000,SEQUENCE(E1,1))

Where $A$3:$A$10000 is your list of numbers from the pivot table and E1 is your number of rows to return.

 

[TINA31415]

Hi, if you have the SEQUENCE() function available - you can try.

=INDEX($A$3:$A$10000,SEQUENCE(E1,1))

Where $A$3:$A$10000 is your list of numbers from the pivot table and E1 is your number of rows to return.

Unfortunately it doesn't look like I have the Sequence function available.

 

[FormR]

it doesn't look like I have the Sequence function

Hi, you could try something like this instead.

Book1
	A	B	C	D	E
1				Choose:	5
2	Full list
3	64020				Result
4	99955				64020
5	50479				99955
6	45981				50479
7	22044				45981
8	69058				22044
9	59318
10	69622
11	65679
12	98889
Sheet1

Cell Formulas
Range	Formula
E4:E12	E4	=IF(ROWS(E$4:E4)<=$E$1,INDEX($A$3:$A$10000,ROWS(E$4:E4)),"")

The formula in E4 is copied down as far as may be required.