repeat cell-contents

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

A1 contains "Smith"
A53 does not contain "Smith"
A459 contains "Smith"
A1072 does not contain "Smith"


How do I get "Smith" to appear in:

B1 thru B52
B459 thru B1071

and nothing in the other cells?

Thanks,
 
Hi Gary
see you post in Excel.misc
Frank

----repost:
Hi Gary
so you only want to duplicate the "Smith" entries. Try the following:
In B1 enter
=A1
in B2 enter
=IF(A2="",B1,IF(A2="Smith",A2,""))
copy down
 
Back
Top