Hi Andi

It would be A1:A200 provided there are no gaps in the data. Count would
return 199, as it would ignore the text in A1.

When you use InsertNameDefine, at the end of the white pane Refers
to, there is a small icon. Click this and it will show you the range
that would be selected by the criterium set.

Regards

Roger Govier



Andibevan wrote:

Hi All,

I am having problems with dynamic named ranges.

On my table I have defect ID's (numerical) running from a2:a200 and the
title"Defect ID" in cell A1

I am using the following formula to dynamically name a range:-

=OFFSET($A$1,0,0,COUNT($A:$A),1)

Will this format of offset select A1:A200 as the named range or A2:200?

From my understanding you can't physically select a dynamically named range
so it is hard to tell what it is selecting

Thanks

Andi