Top Ten Number of the Column

Vicky6615

Spammer
Joined
Jan 31, 2006
Messages
37
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
Joined
Jan 5, 2007
Messages
4,284
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
Joined
Jan 31, 2006
Messages
37
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

MrExcel MVP
Joined
Aug 21, 2004
Messages
16,995
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
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top