ranking problem with league table.

[stevelad12]

Please help,

I have the ranking set up and now i want to set up the automatic ranking but because some people have the same amount of points it comes with N/A
for some entries. how can i get round this please? rank.png

[sktneer]

Hi stevelad12,
Welcome to the Forum.

Attach a sample workbook not an image. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[BadlySpelledBuoy]

Have a look at the attached for a quick and easy way of doing this.
Keep in mind that this approach will rank players with the same scores according to the order they appear in the original table.

You can use formulas to perform actual "tie breaks" based on criteria, but it's a little more complicated and for that you would need to provide a sample workbook and a full explanation of the tie break sequence if based on more than one criteria.

BSB.

[sktneer]

Please find the attached sheet (used BSB's sheet as an example) to see if this is what you are trying to achieve.