| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show results once from a column
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show results once from a column | Excel Discussion (Misc queries) | |||
| 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 subtract column 1 from 2 and show results in 3?HELP! | Excel Worksheet Functions | |||
Threaded Mode
