remove duplicates in multi-line key

[smishler]

Hi all,

I am looking for a calculation to clean up duplicate data in a multi-line key. For example, what I have is:

D01P09

D01P10

D01P09

D01P10

D01P09

D01P10

but what I want is:

D01P09

D01P10

The number of entries that are duplicated varies. Any help is much appreciated. Thanks.

-shawn

[comment]

See:

http://fmforums.com/forum/showpost.php?post/331931/

Alternatively you could a custom function for this.

[smishler]

I used the value list method and it worked like a charm, thanks!