Is there a possibility in Excel to rank the 10 lowest backodds from 1 to 10?
So In column AA I get this ranking from the matrix $F$5-$F$30.
Thanks for helping me out.
Sjaak
Ranking Odds
Moderator: 2020vision
3 posts
• Page 1 of 1
Ranking Odds
by sjaak1943 » Sun Dec 07, 2008 10:09 am
- sjaak1943
- Posts: 174
- Joined: Tue Oct 31, 2006 9:50 pm
- Location: Schagen, the Netherlands
by Castillo » Sun Dec 07, 2008 10:24 am
Hi
This is the way I RANK odds,
In Cell AA5 put =RANK(F5,$F$5:$F$30,1)
Cell AA6 =RANK(F6,$F$5:$F$30,1) etc
This will rank all odds from F5 to F30 with 1 being the lowest.
Hope this helps
Castillo
This is the way I RANK odds,
In Cell AA5 put =RANK(F5,$F$5:$F$30,1)
Cell AA6 =RANK(F6,$F$5:$F$30,1) etc
This will rank all odds from F5 to F30 with 1 being the lowest.
Hope this helps
Castillo
- Castillo
- Posts: 346
- Joined: Thu Mar 16, 2006 11:01 am
- sjaak1943
- Posts: 174
- Joined: Tue Oct 31, 2006 9:50 pm
- Location: Schagen, the Netherlands
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 30 guests