| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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}) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| minimum | Excel Worksheet Functions | |||
| minimum function | Excel Worksheet Functions | |||
| Can I retrieve a value and its format using the minimum function? | Excel Worksheet Functions | |||
| second minimum value | Excel Discussion (Misc queries) | |||
Hybrid Mode
