2nd highest value.

's Computer Specifications

Hello, I know using the Max function I can get the highest value in a
sequence of numbers. My question is, is it possible to find the 2nd, 3rd,
etc. highest values from the same squuence?

's Computer Specifications

Look in HELP for the LARGE() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Darren" <(E-Mail Removed)> wrote in message
news:CC763218-88C0-43FB-A799-(E-Mail Removed)...
> Hello, I know using the Max function I can get the highest value in a
> sequence of numbers. My question is, is it possible to find the 2nd, 3rd,
> etc. highest values from the same squuence?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Choose the highest and second highest from three field	pakkoda	Microsoft Access Queries	7	13th Nov 2009 08:00 AM
Display the Highest, Second Highest, Third Highest and so on...	=?Utf-8?B?Z2ti?=	Microsoft Excel Misc	1	1st Dec 2006 11:39 AM
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates	John	Microsoft Excel Worksheet Functions	3	11th Aug 2006 04:34 AM
Highest Value	Alec Kolundzic	Microsoft Excel Worksheet Functions	16	19th Sep 2004 09:11 AM
Excel VBA - Highest Value and Second Highest Value	Parlatoc	Microsoft Excel Misc	1	2nd Aug 2004 10:44 PM