Finding the greatest value

[t2true]

I need to determine the greatest value in a range of cells. The range i
every 20th cell starting at J7 and ending and J531.
The spreadsheet contains the results from a daily report (30 day
worth). Each report is 20 rows. Out of those cells, I need to find th
greatest value.

Please help

Te

 

[Pete_UK]

Just use MAX( ) with an appropriate range. If you have 30 day's worth
of data, then you would have 30 formulae, although I don't see how 20
rows per day for 30 days gives a range from row 7 to row 531.

Do you have a date column? If so, you could use this to determine the
range for each MAX.

Hope this helps.

Pete

 

[vane0326]

If you like to see the largest vaule in column J then use this formula:


=LARGE(J7:J531,1)


But if you like to see the largest vaule every other 20 rows then i
put this formula in cell K26 and copy it all the way down.

=IF(MOD(ROW(J26)-ROW($J$7)+1,20)=0,LARGE(J7:J26,1),""

 

[Guest]

Hi,

If you meant, finding the greatest value among J7, J27, J47, J67, .........,
use the following array formula, and confirm with CTRL-SHIFT-ENTER.

=MAX(IF(MOD(ROW(J7:J531)-6,20)=0,J7:J531,-1E+100))

Regards,
B. R. Ramachandran

 

[RagDyer]

Try this for a range of J7 to J587:

=SUMPRODUCT(MAX((MOD(ROW(J7:J587)-7,20)=0)*J7:J587))
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================