Thanks for the confirmation :-). Do you know if this is "fixed" in Excel 2007?

"Toppers" wrote:

Phil,
It does appear from further testing that you DO get an error if
the range is dynamic i.e. use OFFSET function.

"Philip J Smith" wrote:

Hi.

I have checked that several times, copying from a list of range names
generated from Insert, Name, Paste, Paste List.

Does it matter that the ranges are variable length ranges determined by the
OFFSET function?

e.g. tblAbsResidual
=OFFSET('ETM Cash Db and Regression'!$M$13,'ETM Cash Db and
Regression'!$Q$5,0,'ETM Cash Db and Regression'!$S$5-'ETM Cash Db and
Regression'!$Q$5,1)

Regards
Phil.

"Toppers" wrote:

Phil,
Works OK for me. Just check range name in A1 is correct as this
will give a #REF! error if incorrect.

"Philip J Smith" wrote:

When I use {=FREQUENCY(INDIRECT($A$1),Bin_Range)} I get a column of #REF!.

A1 can contain one of two valid range names.
The frequency function works when either of the two are entered directly or
even when an IF function replaces the INDIRECT function e.g.
{=FREQUENCY(IF($B$1=1,Range1,Range2),Bin_Range)}

In all cases the formulae are entered as array functions.

Does anyone know why it doesn't work?

Regards

Phil