Hi there,
I trying to create a sheet that will take a set of variable data and extract various information from it.
I have worked out how to get the largest and smallest value from the data =LARGE(A1:A150,1) and =SMALL(A1:A150,1) aswell as the average.
Yet what I can't seem to do is work out is how to take the last value entered into the data and display it elsewhere.
For example, using columns.
Day Data
1 2
2 4
3 9
4 4
5 1
I would like to take the value for day 5 and use it elsewhere but when I enter day 6's data, I would like this then to replace day 5 and so on with each new day's data.
I looked through the function helps files in Excel XP but could not find any help there.
I enter the data onto one work sheet but display the calc's on another sheet and that is where I would like the last entered data value shown.
Is this possible?
Thanks in advance.
Guy
I trying to create a sheet that will take a set of variable data and extract various information from it.
I have worked out how to get the largest and smallest value from the data =LARGE(A1:A150,1) and =SMALL(A1:A150,1) aswell as the average.
Yet what I can't seem to do is work out is how to take the last value entered into the data and display it elsewhere.
For example, using columns.
Day Data
1 2
2 4
3 9
4 4
5 1
I would like to take the value for day 5 and use it elsewhere but when I enter day 6's data, I would like this then to replace day 5 and so on with each new day's data.
I looked through the function helps files in Excel XP but could not find any help there.
I enter the data onto one work sheet but display the calc's on another sheet and that is where I would like the last entered data value shown.
Is this possible?
Thanks in advance.
Guy