Formula to get max average

D

Daniel Bonallack

I'm in a race with another guy to provide a needed formula
to a banker, and I, of course, am going to cheat by asking
you. Please help.

A1:A100 contains integers from 1 to 1000

I need a formula that will give the highest average across
20 consecutive points. For example, AVERAGE(A18:A37) may
be the highest average.

Thanks in advance for a swift reply.

Daniel
 
H

Harlan Grove

I'm in a race with another guy to provide a needed formula
to a banker, and I, of course, am going to cheat by asking
you. Please help.
Click to expand...
...

So, uh, why should we help you?
 

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

Similar Threads

Highest 12-Month Period Average Over Range of Months 8
Adding or to previously provided Average If Array function 4
Adding a row to worksheet does not update cell references in another. 5
formula to get true average 2
Trying to set up a cross reference chart, best way to copy formulas? 2
Error in AVERAGE(IF...) formula; involves Zero Value and Blank Cells 6
Comparing then populating 1
SUMPRODUCT QUESTION?, Ratios 3

Top