Remember a previous cell's value
 

I run a fantasy racing league with some friends. I am trying to find out how
to return a previous cell's value, such as a player's rank from last week. I
am doing it manually now, but there has to be a better way. Thanks!

Hi

not sure what you mean by a previous cell's value

do you mean in A2 you want the value that is in A1?
if so the formula
=A1
in A2 will give it to you

Cheers
JulieD


"Goody" wrote in message
...
I run a fantasy racing league with some friends. I am trying to find out
how
to return a previous cell's value, such as a player's rank from last week.
I
am doing it manually now, but there has to be a better way. Thanks!

NO, I mean that if a cell's (A1 for example) value was 1 one week, and then
A1 is 2 this week, how do I get excel to display the previous value in A1?

"JulieD" wrote:

Hi

not sure what you mean by a previous cell's value

do you mean in A2 you want the value that is in A1?
if so the formula
=A1
in A2 will give it to you

Cheers
JulieD


"Goody" wrote in message
...
I run a fantasy racing league with some friends. I am trying to find out
how
to return a previous cell's value, such as a player's rank from last week.
I
am doing it manually now, but there has to be a better way. Thanks!

AFAIK you can't
if you type over the top of a value it goes
if you need to keep a record of previous values then this is generally done
via the use of columns with dates on them

sorry i can't be of more help
Cheers
JulieD



"Goody" wrote in message
...
NO, I mean that if a cell's (A1 for example) value was 1 one week, and
then
A1 is 2 this week, how do I get excel to display the previous value in A1?

"JulieD" wrote:

Hi

not sure what you mean by a previous cell's value

do you mean in A2 you want the value that is in A1?
if so the formula
=A1
in A2 will give it to you

Cheers
JulieD


"Goody" wrote in message
...
I run a fantasy racing league with some friends. I am trying to find
out
how
to return a previous cell's value, such as a player's rank from last
week.
I
am doing it manually now, but there has to be a better way. Thanks!

Goody

You would have to store that value somewhere when it is entered in order to
retrieve it after you overwrite it with a new value.

This would probably involve VBA code.


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 09:37:05 -0800, "Goody"
wrote:

NO, I mean that if a cell's (A1 for example) value was 1 one week, and then
A1 is 2 this week, how do I get excel to display the previous value in A1?

"JulieD" wrote:

Hi

not sure what you mean by a previous cell's value

do you mean in A2 you want the value that is in A1?
if so the formula
=A1
in A2 will give it to you

Cheers
JulieD


"Goody" wrote in message
...
I run a fantasy racing league with some friends. I am trying to find out
how
to return a previous cell's value, such as a player's rank from last week.
I
am doing it manually now, but there has to be a better way. Thanks!

a simple way to do it is

each week use <edit <move or copy sheet
Select <make copy and when the new sheet is formed rename the sheet. to be
that of the current week. modify this sheet for the current data.

You could also set the data up appropriately and use a pivot table to show
any given week .

"Goody" wrote:

NO, I mean that if a cell's (A1 for example) value was 1 one week, and then
A1 is 2 this week, how do I get excel to display the previous value in A1?

"JulieD" wrote:

Hi

not sure what you mean by a previous cell's value

do you mean in A2 you want the value that is in A1?
if so the formula
=A1
in A2 will give it to you

Cheers
JulieD


"Goody" wrote in message
...
I run a fantasy racing league with some friends. I am trying to find out
how
to return a previous cell's value, such as a player's rank from last week.
I
am doing it manually now, but there has to be a better way. Thanks!