Hello all

I have a column of data made up of 100 cells. Some cells have a unique value
and others the same value. Using a formula in another column, is there a way
I can be left with just a list of unique values e.g. if X comes up 3 times in
the original column how can I show it just once in another?

I know I can use remove duplicates in excel but I don't want to as I don't
want to have to use macros

thanks


--
James.