+ Reply to Thread
Results 1 to 13 of 13

Song competition - ranking order and breaking ties

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Song competition - ranking order and breaking ties

    =H2 + (L2/100) + (M2/1000) + (N2/100000) + (O2/1000000) + (P2/10000000) + (ROW()/1000000000)

    Also instead =Large($D2:$G2,1) so on 2, 3. Put in =LARGE($D2:$G2,COLUMN(A1)) Copy across and down.

    Here other way of tied break sample file.
    Info are in the file.

    Cheers
    Attached Files Attached Files

+ 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