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.

--------------------
(MS-Exl-Learner)
--------------------



"MS-Exl-Learner" wrote:

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)
--------------------



"Jim" wrote:

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