Dig out the "top 10" numbers from 1 column

[Dror Admon]

Hi,
i have a column with several hudreds of numbers and i
would like to use a function that can dig out the "top 10"
values, numbers, out to the next column Cell side to Cell
for example if i found one value from the "top 10" and it
resides in cell D4 i would like it to be copied to cell E4
(from the right or left it doesnt matter.

thank you.

Dror Admon

 

[Dave R.]

Not exactly sure what you're trying to do, but if your #s are in A1, A100:

in B1 put =LARGE(A$1:A$100,ROW())
then copy it down through B10.

If you are wanting the top 10 listed side-ways, you can use in D1:
=LARGE($A1:$A100,COLUMN()-3) then copy this over to the side 10 columns.

Similar, you can use an array formula entered on 10 cells at once sideways;

{=LARGE($A$1:$A$33,COLUMN(INDIRECT("1:10")))}

or up and down, just change "column" to "row".

 

[Dror Admon]

what im trying to do is this;
1 225
2 220
3 224
4 203
5 220
6 222
7 217
8 214
9 232
10 230
11 194
12 212
13 222
14 213
15 230
16 237
17 225
18 198
19 231
20 193
lets assume this is my table, on the left i have the cells
a1,a2,a3,a4, etc, on the right i have the cells
b1,b2,b3,b4 etc, on the b column i have numeric values i
would like to write a function that will check from top to
bottom the values from the larger to the smaller, from
this value checking i would like to copy to the oposite
cell in column c the "top 10" values,
example: on cell b16 i have the largest value in all the
column i want this value to be copied to cell c16, and so
on until i'll get the "top 10" largest values in all the
column.

i hope i explained my self better this time.

thank's
Dror Admon

 

[Frank Kabel]

Hi
enter the following in C1:
=IF(B1>=LARGE($B$1:$B$30,10),B1,"")
and copy down for all rows