General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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
Show More
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 :-)
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
Please login to post a reply.
Wonder
Instance ID: 13539