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,

Gary
 
Frank,

Yes.

Per your instructions:
Only B1 contains =A1
B2 contains =IF(A2="",B1,IF(B1="",A2,""))
B2 was copied from B2 thru B65536

==================================

But:

The FIRST time A... contains data, B... contains data.
The SECOND time A... contains data, B... contains nothing.
The THIRD time A... contains data, B... contains data.
The FOURTH time A... contains data, B... contains nothing.

(It alternates this way throughout the worksheet).

What am I doing wrong?

Gary

======================================
 
Hi Gary
but according to your example data
-----
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
---
this was what you were trying to achieve. Or am I missing something
A1-> first time data occurs -> B contains data
A53 -> second time data occurs -> B does not contain data
a459 -> third time data occurs -> B contains data
....
But according to your response there is something else...

Frank
 
Frank,

I'll simplify my example.

I want
A1 contains "Smith" B1 to contain "Smith"
A2 is empty B2 to contain "Smith"
A3 is empty B3 to contain "Smith"
A4 contains "Jones" B4 to be empty
A5 is empty B5 to be empty
A6 is empty B6 to be empty
A7 contains "Smith" B7 to contain "Smith"
A8 is empty B8 to contain "Smith"
A9 is empty B9 to contain "Smith"
A10 contains "Adams" B10 to be empty
A11 is empty B11 to be empty
A12 is empty B12 to be empty

Does this help?

Thanx,

Gary

============================
 
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

Frank
 
Back
Top