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!

can an array do this.....
 

Select C1:E3, put in

=IF(ROW()=$A$1,$A$1+(COLUMN()-2),"")

and array enter

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"dh13134" wrote in message
oups.com...
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!

can an array do this.....
 

ie put it in formula bar and then array enter

Regards
Ken...............


"Ken Wright" wrote in message
...
Select C1:E3, put in

=IF(ROW()=$A$1,$A$1+(COLUMN()-2),"")

and array enter

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"dh13134" wrote in message
oups.com...
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!