Dynamic Range without double entries

[Acid-Sky]

Hi,

i am trying to create a dynamic range... but... in this case the entries are sometimes doubled..

e.g.
12223
12234
12235
12235
12245

so... how do I get rid of double entries (in the example I would want the 12235 to appear only once in the list... not twice)?

some hints/ideas?

 

[jindon]

Hi

try AdvancedFilter for Unique values