New Posts For Thread: excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/27208317/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????thanksit should already be reading the value. but you could try using somtheing along the lines of =a1+0 to ensure conversion to number.https://community.betfair.com/general_betting/go/thread/view/94082/27208317/excel-help?post_id=488840433#488840433it should already be reading the value. but you could try using somtheing along the lines of =a1+0 to ensure conversion to number.Fri, 11 Mar 2011 15:06:01 -0600Normally 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 vhttps://community.betfair.com/general_betting/go/thread/view/94082/27208317/excel-help?post_id=488790233#488790233Normally 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 vFri, 11 Mar 2011 05:56:15 -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/27208317/excel-help?post_id=488782725#488782725greetingsif 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:44 -0600