Remember a previous cell's value

[Guest]

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!

 

[JulieD]

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

 

[Guest]

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]

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

 

[Gord Dibben]

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

 

[Guest]

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 .