You have chosen to sponsor your bid up to a maximum amount of .
I need to find an excel formula to solve the following issue:
I want to find out for each provider how many times they have given service "0101" together with one of the following other services: 8920 or 8921 or 8922 or 8923 or 8924 or 8925 or 8935 or 8936 or 8937 or 8938 to each client in column “B”.
Let's say Provider "027049" has given service "0101" and service "8922" by january 31, 2012 to client "2602921657".
What I need the formula or the solution to do in the first place is to quote that event as "TRUE" in front of provider "027049".
The winner of the project will get a datasource from where the code will be tested
As this is a quick project that I will use to continue my own work, I need it done quick and fast.
The bider must have better excel skills that I have. You may come with another solution to get to the final solution.