Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can an array do this.....
A1 will be an incremented value from 1 to 3.
when A1=1, then C1 will be 1+1, D1 will be 1+2, E1 will be 1+3. when A1=2, then C2 will be 2+1, D2 will be 2+2, E2 will be 2+3. when A1=3, then C3 will be 3+1, D3 will be 3+2, E3 will be 3+3. etc..... i'm looking for a single formula that will "internally" increment A1 from 1 to 3, then display the results in an "output range" C1:E3. can an array do this? the method i use now employs VBA: (VERY simplified) let A1=1 copy answers to C1:E1 let A1=2 copy answers to C2:E2 let A1=3 copy answers to C3:E3 any help or alt suggestions would be appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Pass an array to Rank | Excel Worksheet Functions | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |