This is a discussion on Formula to find SECOND largest number in a group... within the Excel Questions forums, part of the Question Forums category; I have a range of 10 numbers that is part of 9 categories. The first range is (D:4,D14). I have ...
I have a range of 10 numbers that is part of 9 categories.
The first range is (D:4,D14). I have the Max number in a hidden cell, but what I'd like to do, is figure a way to find the "NEXT" number in that series in order to creat a formula to subtract the MAX from the NEXT MAX.
The problem is the cells these numbers are in, can change weekly affected by the other 9 categories.
So basically I'd like to know how I can find the 2nd highest number in a series of ten cells that are dynamic?
Juan Pablo González
Thank you so much for you lightning fast response...