+ Reply to Thread
Results 1 to 2 of 2

sort in order but......

  1. #1
    Forum Contributor
    Join Date
    12-20-2006
    Posts
    127

    sort in order but......

    I have a basic league table column B contains members names, column O contains the points, and column D contains a lower points column which is made up into the overall column o points


    i have the following formula which i have used to sort in desc order some scroe figures


    =IF(ISNUMBER(SMALL($O$5:$O$30,ROW()-ROW($O$5)+1)),LARGE($O$5:$O$30,ROW()-ROW($O$5)+1),"")

    This sorts the high scores into descending oredr but i'd like to rank the scores in name order. If a score is the same then i'd like the names with the same points to be ranked by column b (highest being best) and then if the same in name order.

    not sure how to go about this next bit?

  2. #2
    Forum Contributor
    Join Date
    12-20-2006
    Posts
    127

    Still Stuck Anyone Got Any Ideas?

    Still Stuck Anyone Got Any Ideas?

+ 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