min IF - Bob Philips follow up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
=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
 
Thanks Teethless... nice name

Teethless mama said:
=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
Click to expand...
 
Back
Top