Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
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! |
#6
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |