Excel expert needed

This project was awarded to deepbluetech for $30 USD.

Get free quotes for a project like this
Project Budget
$30 - $50 USD
Total Bids
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.

Awarded to:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online