Hi Francis,

I don't believe that Remove duplicate is available in 2003. There is an
add-in but I know you have to buy it.

There is also an alternative. You can use Advanced Filter. Go to Data,
Advanced Filter. On the action, you can either filter the list, in place OR
Copy to another location. If you plan to paste it onto another place, just
use Copy to another location as it will save you from having to copy-paste it
yourself. If you do select this, you will enable the "Copy to:" option.

On the list range, select your cells, which is A1:A100.

On the Copy to range, point it to wherever you want it to copy to (i.e. B1)

Then make sure you tick the box "Unique records only".

Then hit OK.

Storm


"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