Pågående

I need an Excel expert to help me find a solution to this problem via a formula or macro - 09/09/2018 17:25 EDT

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.

Etc.

Ideally to tell me which scenario best fits my example

Kompetens: Databehandling, Databasprogrammering, Excel, Visual Basic

Visa mer: 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, i need excel expert, i need seo expert for my, i need seo expert, i need someone to help me for my assignment of service marketing, i need someone to help me write a paper on leviathan thomas hobbes, i need an expert to help me with facebook concerns, i need excel help, i need excel help in agra

Om arbetsgivaren:
( 0 omdömen ) Toronto, Canada

Projekt-id: #17736278

Tilldelades:

urgentprogrammer

I know excel. I can make that for you. Let's talk please. I can show you what you need, plus a lot of other tricks of the trade. Thanks!

$25 CAD inom 1 dag
(0 omdömen)
0.0

3 frilansare har i genomsnitt lagt bud på $25 för detta jobb

rIbrarahmed

hi, I am very good in data entry having good typing speed as well and also very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself Mer

$25 CAD inom 1 dag
(15 omdömen)
3.8
$25 CAD inom 1 dag
(0 omdömen)
0.0