sequence - to show all not only first 10? how to

Frequent Contributor



I like to show the data in my pivot table as all not the first 10 as per the formula


=INDEX(FILTER('Input Data'!$G$6:$L$18,'Input Data'!$J$6:$J$18>$I$6),SEQUENCE(10),{1,2,4})


under sequence it show the first 10 only, how can I display al date , for row 1, 2, 4>

formula is right, just at it's showing first 10 items.  - 
Do I just removed the 10 in the ()?


do advise. thanks


Thank you

1 Reply


Remove "SEQUENCE(10)".