Show results once from a column

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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.
 
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.
 
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.
 
Back
Top