Ranking by group and breaking a tie

[monkeyspank]

I would like to Rank value by the month and breaking any ties ( anything where 2 or more might be ranked the same ). I would also like to exclude value that is blank from the ranking.

Month Measured Metric Rank 11/1/2015 11/1/2015 1.384514629 1 11/1/2015 0.725428332 3 11/1/2015 0.628071767 4 11/1/2015 11/1/2015 1.368675384 2 11/1/2015 12/1/2015 12/1/2015 12/1/2015 0.868202299 2 12/1/2015 0.555906058 3 12/1/2015 0.598663348 1 12/1/2015 <tbody> </tbody>

<tbody>
</tbody>

 

[DRSteele]

What criteria should break the tie?

 

[mrshl9898]

Shouldn't the Rank for 12/1/2015 be 1,3,2 instead of 2,3,1?

If so, then try:

=IFERROR(RANK(B2,INDIRECT(ADDRESS(MATCH(A2,A$2:A2,0)+1,2)&":"&ADDRESS(COUNTIF(A:A,A2)+MATCH(A2,A$2:A2,0)+1-1,2))),"")

EDIT: Doesn't include tie breaker sorry.

 

[mrshl9898]

with tie breaker

=IFERROR(RANK(B2,INDIRECT(ADDRESS(MATCH(A2,A$2:A2,0)+1,2)&":"&ADDRESS(COUNTIF(A:A,A2)+MATCH(A2,A$2:A2,0)+1-1,2)))+COUNTIFS(A$2:A2,A2,B$2:B2,B2)-1,"")

 

[monkeyspank]

I'm not sure I am understanding how this formula works. I want to rank metric data in each month and if there are more than one that could be at a certain rank .. I would like a tiebreaker.

Month Metric Rank

10/1/2016	1.359201107
10/1/2016	0.828404297
10/1/2016	0.764605503
10/1/2016	0
10/1/2016	1.949740035
10/1/2016	0.51079656
10/1/2016	1.032300388
10/1/2016	1.184803944
10/1/2016	1.311917819
10/1/2016	0.917141466
10/1/2016	0.984437812
10/1/2016	0.584931827
10/1/2016	0.625241491

<colgroup><col><col><col></colgroup><tbody>
</tbody>