| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with text?
Thanks!
"SteveK" wrote: hmmm this sounds like it might be easier to run in Access instead of excel. Or you could take the out put from access and export it into excel the maybe sort of concatenate it to look like the form you want it in. Just copy the data into a table in access and run a query to display results for rep 2 or whichever. If you are not familiar with access then I would check out those help forums to get assistance. Hope this helps out. Cheers, Steve "dj479794" wrote: I have a column that has sales reps names. Each rep could be listed mulitiple times. in the next column I have a text field. (name of a company). If I wanted to list all the companies associated with a specific sales reps in a single cell. How would I do that? So the output would look like for Rep #2 = "General Electric,Boeing,Toyota" Input: Column A Rep 1 Rep 2 Rep5 Rep 2 Rep 4 Rep 2 Rep 1 Column B Honda General Electric HP Boeing Dell Toyota JPMC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF, Text, and Leading, 000s | Excel Worksheet Functions | |||
| sumif where cells contain Number & Text | Excel Discussion (Misc queries) | |||
| sumif 2 text conditions | Excel Worksheet Functions | |||
| SUMIF exluding text | Excel Worksheet Functions | |||
| Text function within Sumif | Excel Worksheet Functions | |||
Threaded Mode
