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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter & Sort 3
Sorting errs 6
Look up for a value in a s et of ranges 1
Excel Excel: Sort a column with #.#.# number and keep other column 0
Drop Down Sort Button. 2
Use macro to sort column 2
More sort options - do they exist? 4
Function in Excel to count and list number of entries of text valuesin a row. 2

Back
Top