Forum Discussion
bbsin
Oct 23, 2022Iron Contributor
sequence - to show all not only first 10? how to
hi
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
2 Replies
Sort By
- Detlef_LewinSilver Contributor
- bbsinIron ContributorThank you for your help