Hi All,
I require a formula to return the minimum value (date) from a range than spans multiple rows and columns with criteria in both rows and columns. I have attached an example sheet with expected results.
Have tried MINIFS, and MIN INDEX MATCH, but I must be getting something wrong.
Any help will be greatly appreciated.
This maybe: =MIN(FILTER(FILTER($C$6:$J$16, $B$6:$B$16=$L6), $C$5:$J$5=M$5))
Never use Merged Cells in Excel
Howver, in your output example you have all same dates all based only on Contract 1.
Another
Formula:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Boths options work exactly as expected, so thank you both very much.
@zbor, also thank you for spotting the error in the expected results range within the example attachement, I have uploaded a corrected version, including both solutions, should anyone in the future find this post.
Rep added (for both) and thread marked as solved
Updated example attachment
You're welcome and thank you for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks