use the second highest number in a formula or calculation

Cosmos75 · Apr 17th, 2002, 01:17 PM

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 · Apr 17th, 2002, 01:21 PM

=LARGE(area, 2)

regards Tommy

lenze · Apr 17th, 2002, 01:22 PM

Use the Large Function to retrieve the 2nd Largest Number

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

Al Chara · Apr 17th, 2002, 01:22 PM

You want LARGE function

Mark O'Brien · Apr 17th, 2002, 01:23 PM

I'd suggest "Large", myself.

I'm surprised no one has suggested it.

Al Chara · Apr 17th, 2002, 01:24 PM

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

Apr 17th, 2002, 01:22 PM	#4
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You want LARGE function __________________ Kind regards, Al Chara

Apr 17th, 2002, 01:23 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,521	I'd suggest "Large", myself. I'm surprised no one has suggested it. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 01:17 PM	#1
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	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 (2ndB2G14 or even another calculation or formula). How do I do that? Would it incorporate the RANK formula?

Apr 17th, 2002, 01:21 PM	#2
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	=LARGE(area, 2) regards Tommy

Apr 17th, 2002, 01:22 PM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Use the Large Function to retrieve the 2nd Largest Number =Large(Your Range,2)B2G14 etc

Apr 17th, 2002, 01:24 PM	#6
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	I always forget to hit "Topic Review" Too many people beat me to the draw.