Formula to find 2nd largest in a range including negatives, ignoring zeros

[RUMPOLE]

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

 

[RUMPOLE]

See the workbook:https://www.dropbox.com/s/6yxmisafd9b0bum/RUMPOLE%20Formula%20to%20find%202nd%20largest%20in%20a%20range%20including%20negatives%2C%20ignoring%20zeros.xlsx?dl=0

That works as well, thankyou very much Aladin!

Kind Regards
RUMPOLE

 

[RUMPOLE]

Thanks very much Aladin, Jonmo1 and Barry Houdini for your help- greatly appreciated.