Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Show results once from a column

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15,768
Default Show results once from a column

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

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

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Show results once from a column

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.

"T. Valko" wrote:

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

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

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
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




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default Show results once from a column

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default Show results once from a column

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show formulas instead of results Hippopotamus Excel Discussion (Misc queries) 4 January 14th 06 09:55 PM
lookup and show all results JAHanlon Excel Worksheet Functions 3 January 7th 06 11:46 PM
with formulas that show negative results I want to show zero inste brit64 Excel Discussion (Misc queries) 6 August 29th 05 11:12 PM
How do I show the results of filter? [email protected].(donotspam) Excel Discussion (Misc queries) 1 August 2nd 05 09:47 PM
How do I subtract column 1 from 2 and show results in 3?HELP! ks Excel Worksheet Functions 1 March 30th 05 03:58 AM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"