# Top Ten Number of the Column

#### Vicky6615

##### Spammer
Hello Board !

I am in a terrible position today..

previously i sticked in a problem ....din't find the desired result of the topic "Random Change of numbers in a single cell". Now i have stucked again..

What i requires is to find out the Top Ten Numbers out of 5000 numbers

For Example :

In a column (A1:A5000) i have different numbers e.g. (0, -1.68954, 2.76,1146.2568 and so on. There are blank cell also in this column.

Now All the numbers in this column get change every 1 sec.

what i want is to get top ten numbers in next column say (B1:B10) from this column which will be updating continiously as the number in column (A1:A5000) changes.

Kindly Help

Note : Sorting is not the solution, because i want the updated top ten numbers.

Thanking You

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

#### Lewiy

##### Well-known Member
In column B try using:
=LARGE(A1:A5000,1)
=LARGE(A1:A5000,2)
=LARGE(A1:A5000,3)
=LARGE(A1:A5000,4)
Etc.

Or simply:
=LARGE(A1:A5000,ROW(A1))
In B1 and copy it down to B10

#### Vicky6615

##### Spammer
Thanks

Thank You Buddy !

Can you plz look into my first prob i was facing..

i am still not got rid off that problem.

Thanks once again

#### jindon

##### MrExcel MVP
Code:
``````Private Sub Worksheet_Calculate()
With Cells(1, Columns.Count).End(xlToLeft).Offset(,1).Resize(10)
.Formula = "=large(a\$1:a\$5000,row())"
.Value = .Value
End With
End Sub``````

#### royUK

##### Well-known Member
You could use a Custom AutoFilter.

Replies
16
Views
469
Replies
25
Views
881
Replies
5
Views
454
Replies
6
Views
422
Replies
2
Views
464

1,181,647
Messages
5,931,210
Members
436,784
Latest member
amuljono

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back