can an array do this.....

D

dh13134

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!
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
Top