Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
array or IF 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
array or IF formula excel help
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 ezt *rta: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use an array formula as a series in an Excel chart | Charts and Charting in Excel | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
complex excel formula Array how do I convert it to a vba Function | Excel Worksheet Functions | |||
excel array formula | Excel Worksheet Functions | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions |