Finding the greatest value

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

Please help

Ted

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

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 in 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),"")

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

"t2true" wrote:

>
> I need to determine the greatest value in a range of cells. The range is
> every 20th cell starting at J7 and ending and J531.
> The spreadsheet contains the results from a daily report (30 days
> worth). Each report is 20 rows. Out of those cells, I need to find the
> greatest value.
>
> Please help
>
> Ted
>
>
> --
> t2true
> ------------------------------------------------------------------------
> t2true's Profile: http://www.excelforum.com/member.php...fo&userid=3877
> View this thread: http://www.excelforum.com/showthread...hreadid=524627
>
>

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!
==============================================



"t2true" <[email protected]> wrote in
message news:[email protected]...
>
> I need to determine the greatest value in a range of cells. The range is
> every 20th cell starting at J7 and ending and J531.
> The spreadsheet contains the results from a daily report (30 days
> worth). Each report is 20 rows. Out of those cells, I need to find the
> greatest value.
>
> Please help
>
> Ted
>
>
> --
> t2true
> ------------------------------------------------------------------------
> t2true's Profile:
http://www.excelforum.com/member.php...fo&userid=3877
> View this thread: http://www.excelforum.com/showthread...hreadid=524627
>