Formula Help

[Gary Thomson]

Hi Mary,

Put your data series into column B (or insert a column in
front of column A).

In cell C1 you should have:

=MAX($B$1:$B$10000), which returns the max value

In cell C2, you should have:

=AVERAGE($B$1:$B$10000), which returns the average

Now, in cell A1, insert the following formula:

=IF(B1<$C$2,"",COUNTIF($B$1:$B$10000,B1))

and copy this formula down through column A to cell A10000.

Now, in cell C3 (or wherever you like), put the following
formula:

=VLOOKUP(MAX($A$1:$A$10000),$A$1:$B$10000,2,FALSE)

which will return the value with the most occurences
between the average and the maximum.

Happy to Help,

Gary Thomson