Nat Uralice wrote:Ah ok, this definitely seems like it will help me out. However, my inexperience with Excel formulas is coming into play. I figured out which formula will work best (RANK.AVG), but it asks me to fill in more fields to complete it (or else I get a "circular logic" message). It asks for a Number, Reference, and Order fields; I tried selecting one cell for Number, the column for Reference, and 0/descending for Order to no avail. Any suggestions? Thanks for your help with this.
you are ranking A, your score, against B everybody else score.
1 = your score
so your script should rank =rank(a1,$A$1:$A:$9,1) the one signifies if you are ranking top to bottom, or reverse. For reverse replace the 1 with a 0. thats used for ERA and whip