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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value in list
Going from your sample, your High for Day is in column E (though it
would appear to be in column J from your formula) and High is in column B - adjust as required). Enter this in E2 and copy down: =MAX(B$2:B2) Hope this helps. Pete On Jul 31, 4:08 pm, andy wrote: 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value in list
Perfect! Thanks Pete!
"Pete_UK" wrote: Going from your sample, your High for Day is in column E (though it would appear to be in column J from your formula) and High is in column B - adjust as required). Enter this in E2 and copy down: =MAX(B$2:B2) Hope this helps. Pete On Jul 31, 4:08 pm, andy wrote: 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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value in list
You're welcome - thanks for feeding back.
Pete On Jul 31, 4:32 pm, andy wrote: Perfect! Thanks Pete! "Pete_UK" wrote: Going from your sample, your High for Day is in column E (though it would appear to be in column J from your formula) and High is in column B - adjust as required). Enter this in E2 and copy down: =MAX(B$2:B2) Hope this helps. Pete On Jul 31, 4:08 pm, andy wrote: 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)- Hide quoted text - - Show quoted text - |
Reply |
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) |