AndrePrevin
New Member
- Joined
- Jan 13, 2019
- Messages
- 8
Hi all, really need your help
I have a series of values and blanks randomly distributed in one column and I want to set up a formula in the next column which looks at the first column and says, if there is a value in first column then take that value, otherwise if there is a blank then use the last cell in which a number occurred.
But where it gets a bit complicated is - I want the formula to update the value which it uses from the first column every time a new number occurs in that column, meaning that as the first column encounters a new value after a series of blanks, the formula will discard the old or previous value and take the new one
To give an idea of what I mean, column B's formula must display the last value from column A even when it encounters blanks in column A until it encounters a new value in column A at which point it must update its output to that new encountered value from column A
<tbody>
</tbody>
Not sure if this is even possible but I will be really grateful if some kind person could help me with this, please
Thank you
Kind regards
I have a series of values and blanks randomly distributed in one column and I want to set up a formula in the next column which looks at the first column and says, if there is a value in first column then take that value, otherwise if there is a blank then use the last cell in which a number occurred.
But where it gets a bit complicated is - I want the formula to update the value which it uses from the first column every time a new number occurs in that column, meaning that as the first column encounters a new value after a series of blanks, the formula will discard the old or previous value and take the new one
To give an idea of what I mean, column B's formula must display the last value from column A even when it encounters blanks in column A until it encounters a new value in column A at which point it must update its output to that new encountered value from column A
Column A | Column B |
4 | 4 |
4 | |
4 | |
2 | 2 |
2 | |
2 |
<tbody>
</tbody>
Not sure if this is even possible but I will be really grateful if some kind person could help me with this, please
Thank you
Kind regards