sumif with text?

D

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
 
S

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
 
D

dj479794

Thanks!

SteveK said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top