General Betting
There is currently 1 person viewing this thread.
11 Mar 11
09:48
Joined:
Date Joined:
03 Sep 08
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
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
sort by:
Show
per page
Replies: 2
|
By:
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. |
|
By:
it should already be reading the value. but you could try using somtheing along the lines of =a1+0 to ensure conversion to number.
|