Hi
I'm looking for a formula to find the 2nd largest in a range including negatives, but ignoring zero values.
eg, range of values is
8
0
-2
0
-6
-8
-9
I have tried to calculate a formula which gives me -2 as the second largest value, but had no luck.
Can anyone kindly assist?
Kind Regards
RUMPOLE
I'm looking for a formula to find the 2nd largest in a range including negatives, but ignoring zero values.
eg, range of values is
8
0
-2
0
-6
-8
-9
I have tried to calculate a formula which gives me -2 as the second largest value, but had no luck.
Can anyone kindly assist?
Kind Regards
RUMPOLE