I've attached the sample worksheet. I need to be able to type in two criteria, in this case, season and year, and return the min (or max) value between the results. For instance, in Winter 2014, three prices match the criteria, but out of those I need the formula to return the minimum value.
I couldn't come up with any pretty ways to do this. (Also, there appears to be 5 matching cells.)
In A22: Loc 1
E22: =MIN(IF(B2:P2=B22,IF(B4:P4=C22,IF(A5:A18=A22,B5:P18))))
F22: =MAX(IF(B2:P2=B22,IF(B4:P4=C22,IF(A5:A18=A22,B5:P18))))
These are both array formulas, confirmed with Ctrl+Shift+Enter.
min-max IF for seanpcorbett1.xlsx
Last edited by daffodil11; 11-21-2013 at 01:10 PM. Reason: Added attachment
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks