I have a list of data that I'm trying to write a formula for to create a specific count. In one column, I have client id's which is sorted by the client id in order to show where they showed up more than once. What I want to do is create a formula that will count how many times a specific combination occurs in another column if excel see's a match in the client id column.
So for example, my data might look like this:
Client ID Result
123 food
123 gas
127 gas
127 food
131 drink
131 food
149 drink
149 gas
151 drink
151 food
151 gas
Assume Client ID = Column A and Result = Column B. What I want excel to do is tell me how many times the same Client ID in Column A has a resulting combination of both Food and Gas. So in the example above, the formula should be able to run a count with an answer of 3 since clients (123, 127 and 151) all have a result of both Food and Gas.
Any help is appreciated here!
Thank you!
Bookmarks