Rank and match duplicate problem

[guy13]

Hi again,

I am struggling to display some ranked data which has duplicate ranks i.e. two people with joint 1st place positions.

When I match these the duplicate rank only matches one name for both.

See the attach $$. Hope you can help!

[zbor]

You can create rank as:

Please Login or Register  to view this content.

Then everything will work but you can format numbers as 0 decimal places to see only round.

[azumi]

Hope this helps, using array formua, means when ENTERING the formula needs to press CTRL-SHIFT-ENTER button together, and then copied down.

[guy13]

superstar! thanks for the quick response!

[samba_ravi]

B3=INDEX(F$3:F$17,SMALL(IF(H$3:H$17=A3,ROW(H$3:H$17)-ROW(H$3)+1),COUNTIF(A$3:A3,A3)))
Try this array formula

[TMS]

One way, with a Helper column.

Helper - H3:

Please Login or Register  to view this content.

New Rank - I3:

Please Login or Register  to view this content.

Adjusted - B3:

Please Login or Register  to view this content.

All formulae copied down to row 17.


Regards, TMS