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