Minimum function
 

I am working with a spreadsheet with over 300 rows. I need to use the minimum
function and return the minimum value. This needs to be done on more than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})

Minimum function
 

if you have something in the row which would designate whether it needs to be
looked at in your min function, there are several ways to do it
one would be
=min(if(comparison column meets criteria,data column,max(data column)))
entered as an array control-shift-enter
if not the easiest method may be
=min(min(first thirty data points),min(second thirty data points),etc)


"bikemrh" wrote:

I am working with a spreadsheet with over 300 rows. I need to use the minimum
function and return the minimum value. This needs to be done on more than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})

Minimum function
 

I entered this formula and double checked my numbers. there is only one cell
that has a
different number and it still returns a zero. What have I done wrong? I need
to return the
value that is lowest.

=MIN(MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,5 6,60,64,68,72,76,80,84,88,92,96,100,104,108,112,11 6,120,124}),
(MIN("C"&{128,132,136,140,144,148,152,156,156,160, 164,168,172,176,180,184,188,192,186,200,204,208,21 2,216,220,224,228,232,236,240})),
(MIN("C"&{244,248,252,256,260,264,268,272,276,280, 284,288,292,296,300,304})))

"bj" wrote:

if you have something in the row which would designate whether it needs to be
looked at in your min function, there are several ways to do it
one would be
=min(if(comparison column meets criteria,data column,max(data column)))
entered as an array control-shift-enter
if not the easiest method may be
=min(min(first thirty data points),min(second thirty data points),etc)


"bikemrh" wrote:

I am working with a spreadsheet with over 300 rows. I need to use the minimum
function and return the minimum value. This needs to be done on more than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})

Minimum function
 

Here's one idea. I gave the range C8:C304 a range name like "Rng".
Here's an array formula:

=MIN(IF(MOD(ROW(Rng),4)=0,Rng))

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"bikemrh" wrote in message
...
I entered this formula and double checked my numbers. there is only one
cell
that has a
different number and it still returns a zero. What have I done wrong? I
need
to return the
value that is lowest.

=MIN(MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,5 6,60,64,68,72,76,80,84,88,92,96,100,104,108,112,11 6,120,124}),
(MIN("C"&{128,132,136,140,144,148,152,156,156,160, 164,168,172,176,180,184,188,192,186,200,204,208,21 2,216,220,224,228,232,236,240})),
(MIN("C"&{244,248,252,256,260,264,268,272,276,280, 284,288,292,296,300,304})))

"bj" wrote:

if you have something in the row which would designate whether it needs
to be
looked at in your min function, there are several ways to do it
one would be
=min(if(comparison column meets criteria,data column,max(data column)))
entered as an array control-shift-enter
if not the easiest method may be
=min(min(first thirty data points),min(second thirty data points),etc)


"bikemrh" wrote:

I am working with a spreadsheet with over 300 rows. I need to use the
minimum
function and return the minimum value. This needs to be done on more
than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})

Minimum function
 

sorry for not looking at you equation closer
the "c"+{8,12 ... will not reference cells C8,C12,C....
ther equation needs to be
=min(min(c8,c12,c16...


"bikemrh" wrote:

I entered this formula and double checked my numbers. there is only one cell
that has a
different number and it still returns a zero. What have I done wrong? I need
to return the
value that is lowest.

=MIN(MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,5 6,60,64,68,72,76,80,84,88,92,96,100,104,108,112,11 6,120,124}),
(MIN("C"&{128,132,136,140,144,148,152,156,156,160, 164,168,172,176,180,184,188,192,186,200,204,208,21 2,216,220,224,228,232,236,240})),
(MIN("C"&{244,248,252,256,260,264,268,272,276,280, 284,288,292,296,300,304})))

"bj" wrote:

if you have something in the row which would designate whether it needs to be
looked at in your min function, there are several ways to do it
one would be
=min(if(comparison column meets criteria,data column,max(data column)))
entered as an array control-shift-enter
if not the easiest method may be
=min(min(first thirty data points),min(second thirty data points),etc)


"bikemrh" wrote:

I am working with a spreadsheet with over 300 rows. I need to use the minimum
function and return the minimum value. This needs to be done on more than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})

Minimum function
 

Worked great! thanks for you help.

"bj" wrote:

sorry for not looking at you equation closer
the "c"+{8,12 ... will not reference cells C8,C12,C....
ther equation needs to be
=min(min(c8,c12,c16...


"bikemrh" wrote:

I entered this formula and double checked my numbers. there is only one cell
that has a
different number and it still returns a zero. What have I done wrong? I need
to return the
value that is lowest.

=MIN(MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,5 6,60,64,68,72,76,80,84,88,92,96,100,104,108,112,11 6,120,124}),
(MIN("C"&{128,132,136,140,144,148,152,156,156,160, 164,168,172,176,180,184,188,192,186,200,204,208,21 2,216,220,224,228,232,236,240})),
(MIN("C"&{244,248,252,256,260,264,268,272,276,280, 284,288,292,296,300,304})))

"bj" wrote:

if you have something in the row which would designate whether it needs to be
looked at in your min function, there are several ways to do it
one would be
=min(if(comparison column meets criteria,data column,max(data column)))
entered as an array control-shift-enter
if not the easiest method may be
=min(min(first thirty data points),min(second thirty data points),etc)


"bikemrh" wrote:

I am working with a spreadsheet with over 300 rows. I need to use the minimum
function and return the minimum value. This needs to be done on more than 50
non=-consecutive rows.

this is what I have:

=MIN("C"&{8,12,16,20,24,28,32,36,40,44,48,52,56,60 ,64,68,72,76,80,84,88,92,96,100,104,108,112,116,12 0,124,128,132,136,140,144,148,152,156,156,160,164, 168,172,176,180,184,188,192,186,200,204,208,212,21 6,220,224,228,232,236,240,244,248,252,256,260,264, 268,272,276,280,284,288,292,296,300,304})