Having data in an order(Lowest To Biggest).

[fulldeen]

Hello everybody.
Today i need something easy i hope for those who knows about vba.
Having too much data in a sheet i need to get those rows with data (from Lowest To Biggest)
An attachment is here.
Thank you in advanced as always
*****Remember,,the data is more than 5000 rows..**********

[shg]

You're numbers are stored as text. Select an empty cell, copy, select D1:P14, Paste, Paste Special, tick Add and Values, press OK

Then in D24 and copy right and down,

=SMALL($D1:$P1, COLUMNS($D24:D24))

[fulldeen]

Hi shg!
Sorry my friend but which cell is the first one?
(Select an empty cell, copy, select D1:P14, Paste, Paste Special, tick Add and Values, press OK)

[fulldeen]

Hi shg!
Sorry my friend but which cell is the first one?
(Select en empty cell, copy, select D1:P14, Paste, Paste Special, tick Add and Values, press OK)

[Richard Buttrey]

Seems to be an echo here.

Not sure what you want to know when you say which cell is the first one.

shg means you to pick any empty cell, copy it and use Paste Special Add after you have selected your whole data range D1:P5000 or whatever. This action will convert all your text 'numbers' to numbers proper. You can then use the SMALL() function shg gave you.

If you prefer to have the results alongside your original data then put

Please Login or Register  to view this content.

and copy to R1:AD5000

[fulldeen]

so easy.Not a code at all
Thank you shg and Richard very much.
See you my friends

[shg]

You're welcome.