Array formula in numbers


Joined
Jul 12, 2020
Messages
2
Reaction score
0
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.
 
Ad

Advertisements

Joined
Jul 12, 2020
Messages
2
Reaction score
0
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
 
Ad

Advertisements

Cory Cooper

Moderator
Joined
May 19, 2004
Messages
8,414
Reaction score
322
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top