Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array or IF formula excel help | Excel Discussion (Misc queries) | |||
Can I use an array formula as a series in an Excel chart | Charts and Charting in Excel | |||
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 |