Quote:
Originally Posted by Peter
I have a set of numbers where I need to find the highest value and the next
highest value. I can use MAX to find the highest, but how do I find the next
one?
|
you can use either rank or large function, it depends up on whether duplicate values exist or not.
all the best