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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
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 |