Biff,

Your named range formula may be wrong. At the moment it will start from A1
but create a formula with 0 rows and (count of Column A) amount of columns.
This may be why this is evaluating to 0 in your formula?

Try

=OFFSET(Sheet1!$A$1,,COUNT(Sheet1!$A:$A),1)

Thanks,
Matt

"Biff" wrote:

Hi!

Filters aren't dynamic!

There's nothing wrong with the named range formula:

=OFFSET(Sheet1!$A$1,,,COUNT(Sheet1!$A:$A))

The data is numeric.

Biff

"Matt Lunn" wrote in message
...
Biff,

Not sure why that isn't working but is it necessary to use this method?

Could you use DataFilterAdvanced Filter?

If your method is necessary please post details of the list dynamic
formula
and the type of data it contains.

Thanks,
Matt

"Biff" wrote:

Hi Folks!

Trying to extract uniques from a list and make it dynamic. It works as
long
as there are at least 2 entries in the list. If there is only 1 entry in
the
list the formula errors but i don't understand why.

The formula without the error trap: (array)

=INDEX(List,MATCH(0,COUNTIF(A$1:A1,List),0))

List is a dynamic range name.

With only a single entry in List and A1 being empty, this is how the
formula
evaluates:

=INDEX({1},MATCH(0,0,0))

Match returns #N/A when it should return 1 since 0 matches 0 and it's in
the
first position of the lookup_array and the result of the entire formula
shoud be 1 since 1 is in the first position of the Index array.

Can anyone explain why this is not working?

Thanks

Biff