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
|