Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
To anyone who can help,
I have a Excel file that I need to extract out the Min value and the Max Value out of a specific column looking only at every ninth record starting with row one (a1). It will look like this: a1) 90 a2) 1 a3) 2 a4) 3 a5) 4 a6) 5 a7) 6 a8) 7 a9) 8 a10) 100 a11) 1 a12) 2 a13) 3 a14) 4 a15) 5 a16) 6 a17) 7 a18) 8 a19) 110 I only want to key on the "90","100,"110" and find the min value out of these which is "90". Hope this makes sense. Can anyone tell me who to use the "Min" command to do this keying on every ninth record only in column "A"? Then I need to do the same principle but instead of min I need "Max" which would be "110". Thank You in Advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |