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?
Creating ranks with suffix "T" in case of a tied position
-
-
-
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. -
Re: Creating ranks with suffix "T" in case of a tied position
Here is a sample workbook with data and required results!
-
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
-
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!