You can use a formula like
=MAX(INDIRECT("A1:A"&C1))

This will give you MAX of A1:A20 if C1 contains 20.

Basically build a string which evaluates to a range and pass it to INDIRECT
function and wrap a MAX around it...

"Jay" wrote:

Hi,

I need to do some data analysis on a set of data, basically to perform the
MIN and MAX functions on a column of data, i.e.,
cell(F1) = MIN(D1:D100), cell(G1) = MAX(D1:D100),
cell(F2) = MIN(D101:200), cell(G2) = MAX(D100:200),
.......
cell(F30) = MIN(D3000:D3100), cell(G30) = MAX(D3000:3100)

Something like that.

I was wondering if I can reference these cells in a formula such as below:
MIN(D$(100*i+1):D$((100+1)*i)
for the i in 0,1,2, .... 30, where the i can be another column of data I can
easily fill in incremental data.

Thanks very much



--
Jay