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!

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!

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!