Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Sorting using formulas (Excel 2003)

    I know there is a way to sort numbers using formulas. Can someone help me...

    I have this in a sheet
    A 16%
    B 27%
    C 35%
    D 26%

    and want to use formulas to product this...
    C 35%
    B 27%
    D 26%
    A 16%

    Thanks for the help.

  2. #2
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sorting using formulas (Excel 2003)

    1] Assume your data located at A1:B4
    A B
    A 16%
    B 27%
    C 35%
    D 26%

    2] D1 entered the formula, copied across to E1,

    Then, selected D1 and E1 copied down to row 4 :

    =INDEX($A$1:$B$4,MATCH(LARGE($B$1:$B$4,ROWS($1:1)) ,$B$1:$B$4,0),COLUMNS($A:A))

    Regards
    Bosco

Posting Permissions

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