| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show formulas instead of results | Excel Discussion (Misc queries) | |||
| lookup and show all results | Excel Worksheet Functions | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
| How do I show the results of filter? | Excel Discussion (Misc queries) | |||
| How do I subtract column 1 from 2 and show results in 3?HELP! | Excel Worksheet Functions | |||
Hybrid Mode
