Create list from named range with no duplicates

[sinspawn56]

See attached example

I am trying to create a list of unique values from a dynamic named range.
Any suggestions.

[contaminated]

Assuming that your Dynamic range named as Animal uses this function

=OFFSET(Sheet2!$A$2,0,0,MATCH("*",Sheet2!$A:$A,-1)-1,1)

... function below gets unique values as per you wanted.. Paste this elsewhere, confirm with Ctrl+Shift+Enter (array entered) and copy down as far as neded.

=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX(Animal,SMALL(IF(IF(ISNA(MATCH(Animal,Animal,0)),"",MATCH(Animal,Animal,0))=ROW(Animal)-1,ROW(INDIRECT("1:"&ROWS(Animal))),""),ROW(A1)))))

[sinspawn56]

Will test!