Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value in list
I would like to get the highest value in my list based on 1-minute intervals.
I do not want to get the hightest value for the day because it may not be the highest high at that point. There are 391 minutes in my stock data. Thanks! Time High Low Close High for Day 8:30:59 47.39 47.39 47.39 47.39 8:31:59 47.30 47.02 47.15 47.39 8:32:59 47.29 47.10 47.18 47.39 8:33:59 47.30 47.15 47.19 47.39 8:34:59 47.43 47.17 47.38 47.43 <----------New High 8:35:59 47.41 47.22 47.23 47.43 8:36:59 47.24 47.08 47.10 =MAX(J2:J8) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the next highest value in a list | Excel Discussion (Misc queries) | |||
5 highest then list names | Excel Worksheet Functions | |||
A list of the 8 highest results... | New Users to Excel | |||
How to determine second (and then third) highest value in a list | Excel Discussion (Misc queries) | |||
Highest three numbers in a list | Excel Discussion (Misc queries) |