MicrosoftWondering if this early in the process there is still time to get changes to these dynamic array functions. I think a super useful argument to these would be a TopN optional argument.
So =SORT(A1:A100,,,,10) would sort the data in A1:A100, but only return the top 10. The only way I can see to do that is to put the =SORT() funcition in Cell C1, highlight C1:C10, then edit, and old-school CSE the thing to a hard array.
I might be able to figure out a way nesting FILTER() and SEQUENCE(), but a TopN argument would make it so simple.
Oh wait. This works. Put some random text in R3:R20. This will return the top 10 items. this is ugly, with a capital U.G.L.Y. But... it isn't a CSE formula. I'm sure I could clean this up as I threw this together in about 10min, but still. TopN dude....
=LEFT(FILTER(R3#&SEQUENCE(10,1,0.00001,0.0001),NOT(ISNA(R3#&SEQUENCE(10,1,0.00001,0.0001)))),FIND(".",FILTER(R3#&SEQUENCE(10,1,0.00001,0.0001),NOT(ISNA(R3#&SEQUENCE(10,1,0.00001,0.0001)))))-2)
