Forum Discussion
Solved
Limit length of spill formulas, without errors, but error with IFERROR :-)
I have a set of data that I would like to: 1) filter for particular data - easily accomplished using FILTER. 2) sort according to particular data - easily accomplished using SORT. 3) limit the ret...
AeroSteve Let's say the array you want to pick the top 10 (or fewer) from is in A1#, try this:
=INDEX(A1#,SEQUENCE(MIN(COUNTA(A1#),10)))
AeroSteve Let's say the array you want to pick the top 10 (or fewer) from is in A1#, try this:
=INDEX(A1#,SEQUENCE(MIN(COUNTA(A1#),10)))- Ahh, that'll do it. Thanks Riny
