+ Reply to Thread
Results 1 to 2 of 2

How to use RANK to break multiple ties.

  1. #1
    Brian
    Guest

    How to use RANK to break multiple ties.

    I have a spreadsheet that ranks 55 of our employees on two certain
    catagories, the highest rank being and lowest being 55 in both catagories.
    The two ranks are added up as points in another column and ranked in the same
    manner. A little VBA code is added and the rows are sorted by the total point
    catagory, then ranked by that column.
    Having 55 employees on this sheet, there are many times when there are
    multiple ties. The company wants the tie breaker to be decided on another
    catagory, with the lowest in that catagory being ranked highest. How can I
    test this? I will explain the whole worksheet and the actions next.

    The spreadsheet is started with the 55 employees sorted by store number and
    employee number. The columns are filled with data from reports. The result of
    each column that is ranked is static ( stays with that row ). Then the rows
    are sorted by the by the 'point total'.

    Hope this helps in the explanation a little. I read the definition for the
    RANK function, but it only has one explanation for a tie breaker, which
    describes if there is a two way tie, not multiples.
    Thanx for any ideas in advance.
    Brian


  2. #2
    Jason Morin
    Guest

    Re: How to use RANK to break multiple ties.

    Add the inverse of the third ranking to the sum of the
    first 2. For example:

    A1: 88 (sum of 1st 2 rankings for employee 1)
    A2: 88 (sum of 1st 2 rankings for employee 2)
    B1: 12 (third rank for employee 1)
    B2: 20 (third rank for employe 2)

    C1: = A1+1/B1 = 88.083
    C2: = A2+1/B2 = 88.05

    Sort descending on column C.

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >I have a spreadsheet that ranks 55 of our employees on

    two certain
    >catagories, the highest rank being and lowest being 55

    in both catagories.
    >The two ranks are added up as points in another column

    and ranked in the same
    >manner. A little VBA code is added and the rows are

    sorted by the total point
    >catagory, then ranked by that column.
    >Having 55 employees on this sheet, there are many times

    when there are
    >multiple ties. The company wants the tie breaker to be

    decided on another
    >catagory, with the lowest in that catagory being ranked

    highest. How can I
    >test this? I will explain the whole worksheet and the

    actions next.
    >
    >The spreadsheet is started with the 55 employees sorted

    by store number and
    >employee number. The columns are filled with data from

    reports. The result of
    >each column that is ranked is static ( stays with that

    row ). Then the rows
    >are sorted by the by the 'point total'.
    >
    >Hope this helps in the explanation a little. I read the

    definition for the
    >RANK function, but it only has one explanation for a tie

    breaker, which
    >describes if there is a two way tie, not multiples.
    >Thanx for any ideas in advance.
    >Brian
    >
    >.
    >


+ 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