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
 
G

Guest

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
Excel Formula 2
And... 6
Referencing rows to columns 3
how to copy the contents from last cell 2
IF - AND - OR statement? 3
How to copy variable data from 2 worksheets into a seperate 3rdworksheet 12
How to supress #N/A in an array formula. 5

Top