If you are using 2007 you can use the menu function 'Remove duplicates'.
Sorry that I am not sure whether this is available in previous versions.

Another way is Sort Column A in ascending order. Apply thiis formula in B2
and then copy that upto B100. This will return the distinct values in Column
B. Copy the entire column and Paste special there itself and sort to get the
unique list.

=IF(A3<A2,A2,"")


If this post helps click Yes
---------------
Jacob Skaria


"Francis" wrote:

Column A1 through A100 contains a list of names, some of which are
duplicated. what is the formula in Column B that will list only the names in
column A, but only list them once if they are duplicated and also names that
are not duplicate

TIA
--

Thank You

cheers, francis