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