Creating ranks with suffix "T" in case of a tied position

  • I have pricing data for 4 firms arranged in col. A:D
    I need to rank these firms to create a ranking table in cols M:P
    I have used RANK.EQ function to create the ranks and now need to add the suffix T for a tied position!

    How can I create this ranking table?



  • Re: Creating ranks with suffix "T" in case of a tied position


    Hey Hrithik,

    Upload a sample book with the data filled in where you want it and how you would like the result to displayed.

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Creating ranks with suffix "T" in case of a tied position


    Can you include your rank formula in place as well? Basiclly make it function. thanks

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Creating ranks with suffix "T" in case of a tied position


    I have this formula that gives the desired result:


    IF(A2="","NL"&IF(COUNTIF($A2:$D2,A2)>1,"T",""),RANK.EQ(A2,$A2:$D2,0)&IF(COUNTIF($A2:$D2,A2)>1,"T",""))
    Can this be simplified?

  • Re: Creating ranks with suffix "T" in case of a tied position


    Hrithik, I believe your formula is as simple as it can be to do the job. There is one small error in it, the test to add a "T" if there is more than one blank cell fails. You need:

    =IF(A2="","NL"&IF(COUNTIF($A2:$D2,"<>")>1,"T",""),RANK(A2,$A2:$D2,0)&IF(COUNTIF($A2:$D2,A2)>1,"T",""))

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!