| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with text?
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
