ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   placing (https://www.excelbanter.com/excel-worksheet-functions/11501-placing.html)

Stig

placing
 
I have a worksheet where I have 20 participators and I keep track of all
their points.
We have 5 rounds and the end of my sheet I have a
RANG-function.(=RANG(N38;§N§7:§N§54)
But when there are participators with the same score, the winner is the one
who had moste points in the last round, sometimes I have to go all 5 rounds
back to find the winner.
Is there a function that will do this for me?
Sorry for my bad english :)

Very glad if someone can help me!

Mvh Stig




All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com