Formula to get min and max with conditions

Hi. Before we get going on this one...

Is your forum profile showing the Excel PRODUCT that you need this request to work with?

The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

Cheers,

Glenn.

Please update your profile NOW to show that.

Since you have a nice new O365... why not use a dyanmic array that updates automatically, instead of a dead old pivot table???

Formula:

Please Login or Register  to view this content.

... And I'm not good at Pivot Tables, I don't like them and don't use them.


The formula is actually reasonably simple. The only bit you need to change is the bit in red:

Formula:

Please Login or Register  to view this content.

All the bits that start with a letter (B, C, D...) are just components - relatively simple mini-formulae. The bit in blue puts them all together. If you're interested in learning/using it, I can explain further...

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.