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: 1
|
By:
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 :-) |