Need tie breaker for ranking

The attached spreadsheet (which has a bunch of hidden columns) is being used to generate points based on ranking and then at the end of the 4 weeks, give a ranking based on the 4 weeks' totals.

The only problem I have right now, is that if there is a tie in the final point score (column V) the rankings (coulmn W) are assigned sequentially in the order of the rows on the spreadsheet (i.e. if Name 3 and Name 4 were tied for third place, Name 3 would be third and Name 4 would be fourth).

What I need is to use column Y as the tie breaker. So, if Name 3 had 16 in column Y and Name 4 had 17, Name 4 would in fact be in thrid place, Name 3 would be in fourth, and then the ranking would continue with 5th and 6th places being assigned sequentially.

I have tried making changes in Column W, but even after many combinations I have still had no success thus far.

Any ideas?