yogi_Compute Rank Based On Values In A Row Of Columns In A Specified Pattern - 2

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

gookon said ...

(for my earlier Blog post on gookon's project see ... yogi_Compute Rank Based On Values In A Row Of Columns In A Specified Pattern

http://yogi--anand-consulting.blogspot.com/2011/08/yogicompute-rank-based-on-values-in-row.html)

 Hello again yogia,sorry for the late response,had to go out of town for a day.In the following spreadsheet,the 4th column under each player shows points awarded to that player after each fixture.The 5th column under each player is a total of the points awarded to that player after each fixture.I am using the 3rd column under each player to determine that players rank from the 5th column under each player.

While the worksheet is currently working correctly(with only 5 test players),it will not if there are identical rank values,that can be fixed but become extremely long when many more players are added.Your method,if it can be tweaked to work correctly would be a far more economical method.
https://spreadsheets.google.com/spreadsheet/ccc?key=0Aqj7-eahzGqPdFhIaDdVVnNvSUthQVhyRWFhUW05MWc&hl=en_US

-------------------------------------------------------------------

In my earlier post I computed the rank for points in the same row ... however that was based on forward data only to alleviate the issue of circular referencing.

So in this case, I have considered computing the rank in one row down from the row where the player points are recorded

yogi_Compute Rank Based On Values In A Row Of Columns In A Specified Pattern

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

gookon said ...
Hello all.I'm having some trouble using the Rank and Offset functions and hoped someone could point me in the right direction.In the following sample for example, in C4 I am trying to enter the rank of B4 from B4,E4,I4,etc. consistently offsetting 3 cells to the right.In F4 I want to enter the rank of E4 from the same cells as C4 and so on.
A B C D E F G H I and so on....
1| 0 0 3 3 0 0
2| 3 3 3 6 1 1
3| 0 3 0 6 1 2
4| 1 4 1 7 3 5
I've been playing with variations of =Rank(B4,Offset(B4,0,3) but keep getting errors and I'm not honestly even sure if this is the best way to achieve what I want.
Any help at all would be greatly appreciated
-------------------------------------------------------
If understood your intent correctly, I propose a little change in your setup as shown in the following proposed solution ...