Array formula in numbers

[Ianatleigh]

I'm currently using an array formula in excel and I've learned that Numbers doesn't work with Arrays. I was looking for some help on translating into something that would work in Numbers.



=AVERAGE (SMALL(AH13:AH32,ROW($1:$8)))

calculating the average of the smallest 8 numbers in a group of 20.
any help would be appreciated.

 

[Cory Cooper]

Hello and welcome.

Maybe something like this would work:

Averaging a List of the 10 Lowest Numbers

C

 

[Ianatleigh]

This has been helpful but as I am not used to Numbers. I have the issue that the 8th and 9th value are the same. I didn’t understand the -1 or how I can add a new value each time and it recalculate the Smallest 8 from 20

 

[Cory Cooper]

Hello,

Is there a Numbers spreadsheet you can share/upload? It may be easier to see it in person - you can make one with just sample data.

C