J

#### JD

entered into the corresponding cells B1-B31, some are less than values (<2).

I want to calculate the maximum weekly average, i.e. the highest value of the

4 or so weekly averages and put it at the bottom of the column. I don't want

a column or cell of weekly averages and the <2 values should be counted as 2.

A1 2

A2 2

A3

A4

A5

A6 <2

A8 6

A9

A10 2

A11

A12 <2

A13

A14 2

Answer = 3 (for this 2 week period)

Thanks