I need an Excel expert to help me find a solution to this problem via a formula or macro

I have three examples that I am trying to compare information from each example independently to a database; I am trying to think of a formula that when I paste the example it will compare it to the database scenarios( Labeled 2-29) and report back with each of the scenarios which information is missing.


In the database: Let null represent "missing information" and 1 represent "completed information".

In the Examples: Let null represent "not required" and 1 represent Required

In Example 1 ideally I am looking for a Scenario that matches the required data points in this case:

Required( marked by "1"): First Name, Address, Province,Postal Code, Phone Number

Scenario 2: Does not satisfy this example; Address,Province, Postal Code,Phone Number are missing

Scenario 3: Does not satisfy this example; Province, Phone number are missing

Scenario 4: Does not satisfy this example; First Name, Province, Postal Code, Phone Number are missing

Scenario 8: Does not satisfy this example; First Name, Address are missing.


Ideally to tell me which scenario best fits my example

Compétences : Traitement de Données, Programmation de bases de données, Excel, Visual Basic

en voir plus : excel formulas, free chat with excel expert, excel experts online help, free online excel help, got it pro excel, free online excel experts, excel expert online chat free, ask excel expert online free, need excel expert, need java expert help, need drupal expert fix webform problem, need excel expert match columns, need excel expert create macro, excel expert help, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need electrical engineering help edmonton, i need excel data entry

Concernant l'employeur :
( 0 commentaires ) Toronto, Canada

Nº du projet : #17736276

Décerné à:


I am Data Scientist by profession with 7 years of professional experience. Solved many database missing and mandatory value issues in complex business data. Please share the complete problem statement for the solution. Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% CAD en 1 jour
(0 Commentaires)

3 freelance font une offre moyenne de $19 pour ce travail


Dear client? I highly value professionalism and hold myself strictly accountable to represent my client’s work. I aim to form a long-term working relationship. For 3 years I’ve worked in Data Processing, Database Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(1 Évaluation)

Hi,I’m ready for any type of data entry work i just need a direction and I’m on it. Providing quality work in minimum time is my attitude.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(0 Commentaires)