Hello,

Because of the returns I'm looking for in this worksheet I cannot use
filters or pivot tables. Also, I'm sorry to post again but I really need
help here and the only I answer I received before was for filters. Formulas
are really needed.

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