Remember Me?

#### Menu

#1
April 10th 07, 09:40 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 1
what function do I use for excel to choose the 2nd highest number

I want excel to determine the 2nd and 3rd highest numbers from a list of
numbers. What function do I use?

#2
April 10th 07, 09:42 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,397
what function do I use for excel to choose the 2nd highest number

check out large() in help

"ematboy" wrote:

I want excel to determine the 2nd and 3rd highest numbers from a list of
numbers. What function do I use?

#3
April 11th 07, 01:57 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 2,886
what function do I use for excel to choose the 2nd highest number

Hi

=LARGE(\$A\$1:\$A\$100,ROW(A1))
will find the largest number in the range A1:A100
as you copy down, ROW(A1) will become ROW(A2). and find the 2nd largest
, then the 3rd largest etc.

--
Regards

Roger Govier

"ematboy" wrote in message
...
I want excel to determine the 2nd and 3rd highest numbers from a list
of
numbers. What function do I use?

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post J-EL Excel Worksheet Functions 0 November 9th 06 07:54 PM J-EL Excel Worksheet Functions 2 November 9th 06 06:46 PM John Excel Worksheet Functions 3 August 11th 06 04:34 AM Emily Excel Worksheet Functions 1 June 27th 06 06:49 AM Keith Excel Worksheet Functions 4 January 19th 05 03:23 PM

All times are GMT +1. The time now is 08:08 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.

# About Us

"It's about Microsoft Excel"

Copyright © 2017