Forums

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

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
starfish and coffee
11 Mar 11 09:48
Joined:
Date Joined: 03 Sep 08
| Topic/replies: 8,055 | Blogger: starfish and coffee's blog
greetings
if i have a column with a ranking formula, and then want a second column assigning a value to the ranking, how do i get excel to read the ranking result, rather than the formula????
thanks
Show More
Loading...
Report Compound Magic • March 11, 2011 11:56 AM GMT
Normally you would use INDEX and the Match functions

It depends if you want to assign a fixed value or a relative cell value to each rank number starting from 1 to whatever.
If you tell me what cell your rank function starts and finishes in and what values you wish to enter next
to rank 1, rank 2 etc... and where those values are located I can probably help with a formula.
Report getintheir • March 11, 2011 9:06 PM GMT
it should already be reading the value. but you could try using somtheing along the lines of =a1+0 to ensure conversion to number.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com