Show results once from a column

[Jim]

Hello,

I would like to ask for help with the following: In column A I have
repetative data. It's the name of my sales people. It looks like this:

Denise
Jim
Jeff
Anthony
Beth
Brian
Judy
Eric
Bonnie
Jim
Jeff
Summer
Cynthia
Brian
Brenda
Ryan
Kay
Jeff
Beth
Jim
Eric
Judy
Bonnie
Kay

I need a formula that I can copy into Column B that extract their name, and
show it in column B only once.

So it will look like this:
Anthony
Beth
Bonnie
Brenda
Brian
Cynthia
Denise
Eric
Jeff
Jim
Judy
Kay
Ryan
Summer

Can anyone help me with this
And thank you.

Jim

 

[T. Valko]

The easiest way to do this is to use a filter. See this

http://contextures.com/xladvfilter01.html#FilterUR

 

[Jim]

A filter nor a pivot table will work because of the calculations I'm doing on
the page. Formula would be best if someone can help me out.

 

[MS-Exl-Learner]

Hi,

Just paste it in B1 Cell and give cntrl+D upto your range. But this
function will show only the original values. If any duplicates found then it
will return blank cells as results.

 

[MS-Exl-Learner]

I forget to mention the function and the same is given below:

=IF(COUNTIF($A$1:$A1,A1)=1,A1,"")

paste it in B1 Cell and give cntrl+D upto your range. After that apply
Autofilter in B Column and select Non Blanks.