Finding the largest 6 numbers in a list

[drag-driver]

Have a list of numbers and need to find the top 6 numbers in the list any help much apreciated. The numbers are all in the same row.

[Tommy Bak]

use the large formula
=LARGE(area;1) returns the highest
=LARGE(area;2) returns the 2. highest

and so on.

regards Tommy

[Aladin Akyurek]

On 2002-03-20 02:49, drag-driver wrote:
Have a list of numbers and need to find the top 6 numbers in the list any help much apreciated. The numbers are all in the same row.

Lets say that your data are in A2:J2.

In A4 enter and copy down till A9, giving 6 highest values:

=IF(COUNT($A$2:$J$2)>ROW()-ROW($3:$3),LARGE($A$2:$J$2,ROW()-ROW($3:$3)),"")

where ROW() computes current row number and row($3:$3) computes the number of rows before the first cell in which the above formula resides.

[Dave Hawley]

Hi DragDriver

Just use the AutoFilter, select "Top 10" and change it to 6