sumif with text?

[dj479794]

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

 

[SteveK]

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]

Thanks!

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