Y y Apr 26, 2004 #1 Is it possible to define a name via a array formula? How could use the CSE method in this contest? Thanks, Alex.
Is it possible to define a name via a array formula? How could use the CSE method in this contest? Thanks, Alex.
C Charles Williams Apr 26, 2004 #2 Hi Alex, just define the name with a refersto that looks like an array formulae: Fred=Sheet1!$A$1:$A$3+Sheet1!$B$1:$B$3 then either enter =fred as a multicell array formula using CSE or enter =Sum(fred) as a single cell formula etc. regards Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm
Hi Alex, just define the name with a refersto that looks like an array formulae: Fred=Sheet1!$A$1:$A$3+Sheet1!$B$1:$B$3 then either enter =fred as a multicell array formula using CSE or enter =Sum(fred) as a single cell formula etc. regards Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm
P Peter Huang Apr 28, 2004 #3 Hi Alex, Did Charles's suggestion that use a named reference help you? Create named cell references or ranges on multiple worksheets http://office.microsoft.com/assistance/preview.aspx?AssetID=HP052015401033&C TT=3&Origin=HP052024891033 If you still have any concern on this issue, please feel free to post here. Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Alex, Did Charles's suggestion that use a named reference help you? Create named cell references or ranges on multiple worksheets http://office.microsoft.com/assistance/preview.aspx?AssetID=HP052015401033&C TT=3&Origin=HP052024891033 If you still have any concern on this issue, please feel free to post here. Best regards, Peter Huang Microsoft Online Partner Support Get Secure! - www.microsoft.com/security This posting is provided "AS IS" with no warranties, and confers no rights.
