Top Ten Number of the Column

[Vicky6615]

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

 

[Lewiy]

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]

Thanks

Thank You Buddy !

You have made me bit relax... your suggestion was worthfull ...

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

i am still not got rid off that problem.

Thanks once again

 

[jindon]

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]

You could use a Custom AutoFilter.