What part of the answers given in the Worksheet Functions forum where you
also posted this is not working. Are you looking for a VBA solution??? Why
the new thread in this forum...
--
HTH...

Jim Thomlinson


"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