I have a large file of data on a local baseball league. 20 teams. Records are players. I have one field that is batting average. Some players are tied. I can easily sort by the average, but I want to create a ranking of the players from 1 - 320. How can i create a field that is the rank order of another field? I would like ties be be the same position in the ranking and the next player to be the next number, for example: 1,2,3,3,5.
Thanks much for any help.