+ Reply to Thread
Results 1 to 2 of 2

Sort by formula

  1. #1
    Registered User
    Join Date
    03-08-2007
    Posts
    7

    Sort by formula

    I have got two columns and I want to sort them by the biggest number but return the cell to the left of that i.e

    Cats 10
    Dogs 7
    Chickens 5
    Rats 9

    I want to sort them to be like this but by using a formula

    Cats 10
    Rats 9
    Dogs 7
    Chickens 5

    Could anyone help me please

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103
    =index($A:$A,match(large($B:$B,row(a1)),$B:$B,0))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1