If you change your desktop cell reference style to R1C1 then =R[-1]C will
work when placed in the empty cells. The Excel defaut cell referemce style
is A1.

"hccatmo" wrote:

Good afterning,
I have:
A B ............
1 Me You
2 " You
3 " "
4 Her "
. " "
.
.
.
Like to get
A B ............
1 Me You
2 Me You
3 Me You
4 Her You
. Her You
.
.
.

I have seen it done by changing to R1C1 and =R[-1]C but it does not work on
mine desktop? Thx.
cg