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?

Homework?

--
Don Guillett
SalesAid Software

"Old Northern" <Old wrote in message
...
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?

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?

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"