IF or Array formula excel .. help !
 

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

IF or Array formula excel .. help !
 

You can put this formula in the empty cells

=IF(C2="","",INDEX($A$1:A1,MAX(IF($A$1:A1<"",ROW( $A$1:A1)))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
oups.com...
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

IF or Array formula excel .. help !
 

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.