Producing a top 30 list

[Anthony Slater]

I have a 4 columns containing values.

How can I produce 4 seperate columns containing the top 30
(or whatever) values? I know the MAX function but that
only produces one number.

Any ideas?

 

[Peo Sjoblom]

=LARGE($A$2:$A$200,ROW(1:1))

copied down 30 rows will give you 1,2 and so on

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Stephen Bye]

You can use the LARGE worksheet function to get the highest, second highest,
third highest etc. value.

You could use AutoFilter, ask it for the top 30 values, and then copy and
paste them elsewhere.

 

[AlfD]

Hi!

Use the worksheet function LARGE(array,k) where k=1 gives the largest
k=2 the second largest etc.

Al

 

[Anthony Slater]

Works a treat !

One slight problem though: -

Some of values are duplicate and so the formula produces
the same value twice.

What do you suggest to only list the top 30 unique values?

 

[AlfD]

Hi!

You couild use DATA>Advanced filter to produce lists of unique value
for each column. Then use LARGE().

Al