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 JulesWinnfield • March 12, 2011 10:45 PM GMT
Not sure I understand what you're asking here but, I think you want to override the result of the formula with a manually entered rank?  Is that right?

If you assume you have the formula in Col A, and want to put the override values in Col B then you can add another formula in Col C that will use the forumula from A unless an override is entered in B as follows:

in C1, put: =IF(B1="",A1,B1)

Copy from C1 as far down as you want.

Then wherever you want to use the ranking in your sheet, take it from Col C.

I've probably just answered the wrong question though :-)
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com