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