We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
10 May 10
15:08
Joined:
Date Joined:
03 Sep 08
Hi
I want to assess ratings using the second ranked as the index marker
E.g with a set of ratings thus:-
105
100
95
93
91
The toprated will have an index value of 105, second rated 100 then 95,93,91
73, 72, 70, 64, 63 would return 101, 100, 97, 89, 88
What would be the excel formula to identify the second ranked and base the calculations on it?
Thanks!
I want to assess ratings using the second ranked as the index marker
E.g with a set of ratings thus:-
105
100
95
93
91
The toprated will have an index value of 105, second rated 100 then 95,93,91
73, 72, 70, 64, 63 would return 101, 100, 97, 89, 88
What would be the excel formula to identify the second ranked and base the calculations on it?
Thanks!
sort by:
Show
per page
Replies: 5
|
By:
have a look at the LARGE function i.e. large(A1:A10,2) will give you the 2nd largest value in the range A1:A10. Should be simple enough to take the values away from that to do what you need
|
|
By:
This should work, probably be able to shorten it though :)
=ROUND(((A1-LARGE($A$1:$A$10,2))+LARGE($AD$1:$AD$10,2))/LARGE($AD$1:$AD$10,2)*100,0) Just copy and paste it down your list assuming the first cell is A1 and the range of values in A1:A10 |
|
By:
=ROUND(((A1-LARGE($A$1:$A$10,2))+LARGE($A$1:$A$10,2))/LARGE($A$1:$A$10,2)*100,0)
|
|
By:
Just replace the AD's to A didn't like my last post for some reason
|
|
By:
that will do, cheers
|