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 &quot;T&quot; 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 &quot;T&quot; 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 &quot;T&quot; 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 &quot;T&quot; 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!