bertusavius
Board Regular
- Joined
- Feb 28, 2008
- Messages
- 82
I'm facing a small problem I can't figure out.
I've got a table and in a particular column there's a number of values. Not all the cells in this column are filled however, so there's an irregular en variable sequence of filled and empty cells in this column.
I would like to let excel repeat the value of the filled cells down the empty cells below the filled cells, without having to use macros.
So for example I'd like to let excel repeat the value in cell a1 in the empty cells below a1 untill there is anonther filled cell in the column. This value will be repeated also until the next filled cell, etc.
I sure hope it's not too cryptic.
Thanx in advance.
I've got a table and in a particular column there's a number of values. Not all the cells in this column are filled however, so there's an irregular en variable sequence of filled and empty cells in this column.
I would like to let excel repeat the value of the filled cells down the empty cells below the filled cells, without having to use macros.
So for example I'd like to let excel repeat the value in cell a1 in the empty cells below a1 untill there is anonther filled cell in the column. This value will be repeated also until the next filled cell, etc.
I sure hope it's not too cryptic.
Thanx in advance.