How do I reference and sort a range of numbers in Excel 97?

O

Old Northern

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?
 
F

Frank Kabel

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

Old Northern

Thanks for the replies.

Don: Nope, I'm working on a complex datasheet. I'm trying to solve the
problem without too many nested formulas.

Frank: Thanks for the suggestion. I'll try this.

"old northern"
 
Top