use the second highest number in a formula or calculation

[Cosmos75]

I have a list of numbers.

This list is not sorted and I don’t want to sort it.

I want to use the second highest in a formula or calculation (2nd*B2*G14 or even another calculation or formula). How do I do that?

Would it incorporate the RANK formula?

 

[Tommy Bak]

=LARGE(area, 2)

regards Tommy

 

[lenze]

Use the Large Function to retrieve the 2nd Largest Number

=Large(Your Range,2)*B2*G14 etc

 

[Al Chara]

You want LARGE function

 

[Mark O'Brien]

I'd suggest "Large", myself.

I'm surprised no one has suggested it.

 

[Al Chara]

I always forget to hit "Topic Review" Too many people beat me to the draw.