• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Max or Min to find larget or smallest number matching criteria

ralph

New Member
Chandoo,

I am stuck and need some help.

I have a complex spread sheet that produces a range of data, with Names (concatenated text) in the first column and several columns deep with repetitive names. Below the range, I have a summary formula which lists all of unique Names. I would like a formula similar to sumif but instead for adding it would copy the largest number in a column that matches a criteria (Name). I would also need it to find the smallest number that matches the criteria as well. I tried Dmax and Dmin but could net get it to work.

Can you provide such a formula?
 

Hui

Excel Ninja
Staff member
Ralph


Have a look at MrExcel's post on this


http://www.mrexcel.com/forum/showthread.php?t=13192
 

Hui

Excel Ninja
Staff member
Ralph


Have a look at Mr Excel's post on this


http://www.mrexcel.com/forum/showthread.php?t=13192
 
Top