On Oct 27, 12:45 pm, wrote:
I would like the copy content from cell A1 to A2, A3 A4, ETC.
A5 cell content is different and i want copy its content to A6, A7,
A8, ETC.
This sequence repeats for ever.
Is there an array formula or an =if( formula i can insert either below
the
target cell or adjacent to it accomplish such result.

"4508123456"
X
X
X
X
"4508789456"
Y
Y
Y
Y
Y
Y
"4508258258"
Z
Z
Z
Z
Z
Z
In other words, I want to replace X Y Z with number above it ("4508- -
- - - -")http://crt.fcpages.com/sample%20xls%20file.xls

Try;

=If(C2<"",Lookup(9.99999999999999e307,$A$1:A1),"" )

Enter

Hope this helps.