Oct 23 2022 12:00 AM
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
Oct 23 2022 01:33 AM