use helping column E

in cell E2 put this formula

=IF(B2="","",IF(A2="",E1,A2))





On Jan 11, 2:24*pm, "Obonden" <kjeblo(æt)frisurf.no wrote:
I have several big sheets and wants to add automatically a value to the cell
if the neighbourcell has a value.

Example:

* * * A * * * *B * * * * C * * * *D
1 * Ohio * Mike * * 78 * * Man
2 * * * * * * Mona * *34 * * Woman
3 * * * * * * John * * *43 * * Man
4 * * * * * * Linn
5 * * * * * * Lisa * * * 44
6
7

This table should automatically - without knowing how many rows that
contains information - be like this:

* * * A * * * *B * * * * C * * * *D
1 * Ohio * Mike * * 78 * * Man
2 * Ohio * Mona * *34 * * Woman
3 * Ohio * *John * * *43 * * Man
4 * Ohio * *Linn
5 * Ohio * *Lisa * * * 44
6
7

Kjell