Hi!
I want to ask if there is a way to find the next greatest maximum without a ton of auxiliary coding....Is there a function which does that in Excel? For example from the following list it would give 45:
1
34
45
26
78
29
7
Thanks! a still more awesome function would give 34 if you give it 2 as an input parameter.