Excel Flavour in a Named Formula, Regular or Arrayed ?
 

1. Enter a Named Formula ; and it's not exactly possible to have the
N-F clad in a pair of curly brackets.

2. In a struggle to identify the N-F's flavour (Regular or Arrayed),
are there tell-tale signatures to differentiate one from another ?

3. Is there certain amount of uncertainty in telling the given flavours
apart ?

4. Regards.

Excel Flavour in a Named Formula, Regular or Arrayed ?
 

If I understand you correctly,you don't (can't) use an array formula in a
Name. But it does work. For instance, if you add a Name of say Test, value
MAX(IF($B$1:$B$205,$B$1:$B$20)). This is clearly an array formual, anjd
needs to be CSE entered in Excel. But on the name just ignore it, Then use
=Test, and it works fine. It updates whejn the data changes, etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
1. Enter a Named Formula ; and it's not exactly possible to have the
N-F clad in a pair of curly brackets.

2. In a struggle to identify the N-F's flavour (Regular or Arrayed),
are there tell-tale signatures to differentiate one from another ?

3. Is there certain amount of uncertainty in telling the given flavours
apart ?

4. Regards.