dannywhite
New Member
- Joined
- Feb 28, 2016
- Messages
- 1
Hi All,
Im sure there is an easy way to do this, after a fair bit of googling nothing seems to be fit what i am after hence the post.
I have weekly incremental data been entered into rows, i would like to return the last entry into another cell.
E.g
my formula would be in A1
the data
B1, C1, D1, E1 etc
this would grow
therefore i would like a formula to return the last value entered, the above case it would be E1, as the dataset grows i want A1 to automatically take the last entered value.
i was thinking of somehow searching the next blank cell and return the value to the left as a solution?
Welcome anyone help.
Cheers
Danny
Im sure there is an easy way to do this, after a fair bit of googling nothing seems to be fit what i am after hence the post.
I have weekly incremental data been entered into rows, i would like to return the last entry into another cell.
E.g
my formula would be in A1
the data
B1, C1, D1, E1 etc
this would grow
therefore i would like a formula to return the last value entered, the above case it would be E1, as the dataset grows i want A1 to automatically take the last entered value.
i was thinking of somehow searching the next blank cell and return the value to the left as a solution?
Welcome anyone help.
Cheers
Danny