array or IF formula excel help

W

WESCO.6705

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 xls file.xls
 
S

Stefi

If A1, A6, A13 are real Excel numbers then
=INDIRECT(IF(ISNUMBER(A1),"A"&ROW(),"B"&ROW()-1))
in B1 (dragged down as rwquired) does the job.

Regards,
Stefi


„[email protected]†ezt írta:
 

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

IF or Array formula excel .. help ! 2
IF OR Statements 4
Create if partial match then copy and paste data from one cell to another 1
How to do an IF statement that copy data based on a partial match 0
Help required for formula 2
Multiple results from multiple criteria using IF function 1
IF TYPE FUNCTION 4
IF - AND - OR statement? 4

Top