software

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: www.excelforum.com/member.php...foamp;userid=3877
View this thread: www.excelforum.com/showthread...hreadid=524627Just 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),quot;quot;)--
vane0326
------------------------------------------------------------------------
vane0326's Profile: www.excelforum.com/member.php...oamp;userid=14731
View this thread: www.excelforum.com/showthread...hreadid=524627Hi,

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

quot;t2truequot; wrote:

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

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!
==============================================
quot;t2truequot; gt; wrote in
message ...
gt;
gt; I need to determine the greatest value in a range of cells. The range is
gt; every 20th cell starting at J7 and ending and J531.
gt; The spreadsheet contains the results from a daily report (30 days
gt; worth). Each report is 20 rows. Out of those cells, I need to find the
gt; greatest value.
gt;
gt; Please help
gt;
gt; Ted
gt;
gt;
gt; --
gt; t2true
gt; ------------------------------------------------------------------------
gt; t2true's Profile:
www.excelforum.com/member.php...foamp;userid=3877
gt; View this thread: www.excelforum.com/showthread...hreadid=524627
gt;