Hi
if you only have numeric values try the following for example in B1
=SMALL($A$1:$A$100,ROW())
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany

Old Northern wrote:
Using Excel 97, how can I reference a range of numbers, sort them in
ascending or descending order, and place them in a new range?