New Posts For Thread: excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/27208313/excel-helpgreetingsif 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????thanksNot 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 youhttps://community.betfair.com/general_betting/go/thread/view/94082/27208313/excel-help?post_id=488974853#488974853Not 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 youSat, 12 Mar 2011 16:45:58 -0600greetingsif 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????thankshttps://community.betfair.com/general_betting/go/thread/view/94082/27208313/excel-help?post_id=488782721#488782721greetingsif 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????thanksFri, 11 Mar 2011 03:48:40 -0600