Repeating cell-contents

G

Gary

A1 contains "Smith"
A53 contains "Jones"
A459 contains "Smith"
A1072 contains "Peterson"
A23405 contains "Smith"
A45234 contains "Samantha"

What formula can I use to put:

"Smith" in B1 thru B52
blanks in B53 thru B458
"Smith" in B459 thru B1071
blanks in A1072 thru B23404
"Smith" in A23405 thru B45233
blanks in A45234 thru A65536

Thanks,

Gary
 
F

Frank Kabel

Hi Gary
try the following:
In B1 enter
=A1
in B2 enter
=IF(A2="",B1,IF(B1="",A2,""))
and copy down

HTH
Frank
 
Top