How do I reference and sort a range of numbers in Excel 97?
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" |
All times are GMT +1. The time now is 02:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com