Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Is there a way to sort a range of data in Excel using formulas only?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not sure exactly what you want to do, could you elaborate exactly what you want and what you have?

    Steve

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    I have a pre-defined data range in Excel (e.g., 10 rows) that is populated from an external query. Once this data is refreshed, I would like to effect a descending sort on the data (to a second pre-defind 10-row range) based on the data's numeric values.

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Assuming the range to be sorted is in A1:A10 and the sorted table is in row 1:
    =LARGE($A$1:$A$10,ROW())

    Change the Row() to ROW()-1 less than the row of your sorted table's first row. Or if your sorted data's first row is in row 9, the formula would be:
    =LARGE($A$1:$A$10,ROW()-8)

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I forgot to mention to copy the formula down as far as needed.

  6. #6
    Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland
    Posts
    41
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thanks, just what I needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •