| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the Max, Min values based on certain criteria for an array
10:06 AM 9.56
10:06 AM 9.56 10:06 AM 9.56 10:06 AM 9.55 10:05 AM 9.55 10:04 AM 9.55 10:03 AM 9.55 10:03 AM 9.55 10:03 AM 9.55 10:03 AM 9.55 10:02 AM 9.53 10:02 AM 9.53 10:02 AM 9.53 10:01 AM 9.53 10:01 AM 9.53 10:01 AM 9.52 10:01 AM 9.52 10:00 AM 9.51 10:00 AM 9.51 10:00 AM 9.51 10:00 AM 9.5 10:00 AM 9.51 10:00 AM 9.51 10:00 AM 9.51 10:00 AM 9.51 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.5 10:00 AM 9.51 10:00 AM 9.51 I would like to know how to get the Max Value of say 10:00 AM, Max value of 10:01 AM etc. I would also like a formula to give the Min value and also the start value and end value. There is a seconds component so for 10:00 AM the first value is 9.51 and the last value is 9.51 too, for 10:01 AM the first value is 9.52 and the last is 9.53 etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the last entry in a column based on criteria | Excel Worksheet Functions | |||
| Finding a number based on a criteria | Excel Worksheet Functions | |||
| Finding cell contents based on certain criteria | Excel Discussion (Misc queries) | |||
| Finding cell contents based on certain criteria | Excel Discussion (Misc queries) | |||
| Finding the Largest Number, based on two criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
