Minimum function

[bikemrh]

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,120,124,128,132,136,140,144,148,152,156,156,160,164,168,172,176,180,184,188,192,186,200,204,208,212,216,220,224,228,232,236,240,244,248,252,256,260,264,268,272,276,280,284,288,292,296,300,304})

 

[bj]

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]

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,56,60,64,68,72,76,80,84,88,92,96,100,104,108,112,116,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,212,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})))

 

[Dana DeLouis]

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))

 

[bj]

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]

Worked great! thanks for you help.

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...