| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min IF - Bob Philips follow up
=MAX(INDEX(('data FI'!$T$3:$T$10=W2)*('data FI'!$T$3:$T$10<=T2)*('data
FI'!$V$3:$V$10),0)) Is the formula that works for finding the max value between two dates... change Max ti Min and I return 0. Any help is appreciated |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
min IF - Bob Philips follow up
=MIN(IF(('data FI'!$T$3:$T$10=W2)*('data FI'!$T$3:$T$10<=T2),'data
FI'!$V$3:$V$10)) ctrl+shift+enter, not just enter "John" wrote: =MAX(INDEX(('data FI'!$T$3:$T$10=W2)*('data FI'!$T$3:$T$10<=T2)*('data FI'!$V$3:$V$10),0)) Is the formula that works for finding the max value between two dates... change Max ti Min and I return 0. Any help is appreciated |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
min IF - Bob Philips follow up
Thanks Teethless... nice name
"Teethless mama" wrote: =MIN(IF(('data FI'!$T$3:$T$10=W2)*('data FI'!$T$3:$T$10<=T2),'data FI'!$V$3:$V$10)) ctrl+shift+enter, not just enter "John" wrote: =MAX(INDEX(('data FI'!$T$3:$T$10=W2)*('data FI'!$T$3:$T$10<=T2)*('data FI'!$V$3:$V$10),0)) Is the formula that works for finding the max value between two dates... change Max ti Min and I return 0. Any help is appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| min IF - Bob Philips follow up | Excel Worksheet Functions | |||
| Macro Modification - Bob Philips Are You Out There ? | Excel Worksheet Functions | |||
| INDIRECT Follow On | Excel Discussion (Misc queries) | |||
| follow hyperlink? | Excel Worksheet Functions | |||
| follow link | New Users to Excel | |||
Linear Mode
