Hi,
I have the following dataset:
Date Balance
Jan £100
Feb
Mar £50
Apr £70
May
Jun
Jul
I do not have a balance for Feb at the moment. What I would like to see is £100 (I.E. my last non blank value). For May I would like to see £70 because that is what was my balance in April, and then automatically I would like June to be £70 as this was the value in May etc.
Is this possible? Or something similar?
Thanks
Gnana
I have the following dataset:
Date Balance
Jan £100
Feb
Mar £50
Apr £70
May
Jun
Jul
I do not have a balance for Feb at the moment. What I would like to see is £100 (I.E. my last non blank value). For May I would like to see £70 because that is what was my balance in April, and then automatically I would like June to be £70 as this was the value in May etc.
Is this possible? Or something similar?
Thanks
Gnana