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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat cell-contents 5
Repeating cell-contents 1
Excel Comparing two columns 1
Filter out rows based on the value of a cell 4
Excel Linking Multiple cells to One cell for Results 0
HELP: How to Reverse Cell Content 3
Comparing data from one column with data within another column 6
Convert formula to work in diff areas of worksheet 2

Back
Top