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
|