Show me one of each value in a long list

Hi All,

If I have a list of numbers or values e.g.


1
4
4
4
5
1
6
6
4
6
5

And I want to show a cell (or number of cells if it comes to it) that show each of the values in the list e.g.

1, 4, 5, 6 (each just once)

how would i go about this?

Thanks!
dvent

you could just use data/filter /advanced filter check unique values theneither filter in place or copy to another location

can this sort of filter and copy system be applied using a macro?