creating a second list without duplicates

i am trying to remove all duplicates from a list in a second column not using filters i still meed my original list..

hhmm no clue how to use pivot table

Have a look at the link below for information on creating unique lists:

http://www.get-digital-help.com/2009...om-one-column/

thats not really working for me or i just dont understand it

Perhaps if you posted some sample data it would be easier to help you out.

in A1:A20 i have a list of names some are duplicates. in row b i want to see the same names but without the duplicates. but i will need it as a formula not a copy paste remove duplicates. is it possible

Using the information from the link I posted above, here are two solutions. An array formula and a non array formula.
The only difference is, for neatness sake, I've wrapped each in an IFERROR to clear up any #N/A

Hope that helps.