ExcelBanter - min IF - Bob Philips follow up

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - min IF - Bob Philips follow up (https://www.excelbanter.com/excel-worksheet-functions/136474-min-if-bob-philips-follow-up.html)

John

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

Teethless mama

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

John

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

All times are GMT +1. The time now is 03:55 PM.