Excel expert needed

IN PROGRESS
Bids
38
Avg Bid (USD)
$39
Project Budget (USD)
$30 - $50

Project Description:
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.

Skills required:
Data Entry, Data Processing, Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 50
in 1 days
$ 30
in 3 days
$ 35
in 1 days
Hire nagybatonyi
$ 40
in 1 days
Hire mrbrave
$ 44
in 1 days
$ 30
in 0 days
$ 50
in 1 days
$ 30
in 1 days
$ 30
in 1 days
$ 30
in 2 days