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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Imposs? Speed up 1
Count entries in the column translating to minutes. 5
array formulas using MIN MAX 3
Max If function 1
Question about using MIN/MAX, INDEX with Date range 3
Please Help Qtr Mtch 6
Find max value from 3 cells, return text, but 2 max values same! 5
Finding MIN value in a column between Two Dates in different columns 3

Back
Top