Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value between two dates
What formula would I use to find the highest value between two dates.
Date on col A values on col B |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value between two dates
One way:
Start date in E1 End date in E2 In C1: =IF(AND(A1$E$1,A1<$E$2),B1,"") Fill down as far as A and B go In some cell: =MAX(C1:C25) (adjust 25 to what your last row is) -- Kind regards, Niek Otten Microsoft MVP - Excel "Geo" wrote in message ... What formula would I use to find the highest value between two dates. Date on col A values on col B |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value between two dates
Thank you that works well.
"Niek Otten" wrote: One way: Start date in E1 End date in E2 In C1: =IF(AND(A1$E$1,A1<$E$2),B1,"") Fill down as far as A and B go In some cell: =MAX(C1:C25) (adjust 25 to what your last row is) -- Kind regards, Niek Otten Microsoft MVP - Excel "Geo" wrote in message ... What formula would I use to find the highest value between two dates. Date on col A values on col B |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest value between two dates
On Sat, 15 Aug 2009 13:43:01 -0700, Geo wrote:
What formula would I use to find the highest value between two dates. Date on col A values on col B This formula must be **array-entered**: =MAX((Dates=StartDate)*(Dates<=EndDate)*Values) ---------------------------------------- To **array-enter** a formula, after entering the formula into the cell or formula bar, hold down <ctrl<shift while hitting <enter. If you did this correctly, Excel will place braces {...} around the formula. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Next highest Value | Excel Worksheet Functions | |||
Highest, Second Highest , Third Highest and so on | Excel Discussion (Misc queries) | |||
Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
second highest value | Excel Discussion (Misc queries) |