I think my issue is best displayed with an example:

Here's my rows of data:

Column A
Bob
Dave
Dave
Eric
Simon
Simon
Simon
Simon
Tom
etc....

Is there a formula that can return the following:
Bob
Dave
Eric
Simon
Tom
etc...

i.e. only the unique fields from the array?
Thanks
Matt