已完成

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.

Etc.

Ideally to tell me which scenario best fits my example

技能: 数据处理, 数据库编程, Excel, Visual Basic

查看更多: 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

关于此雇主:
( 0个评论 ) Toronto, Canada

项目ID: #17736276

授予:

Haribskar

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. 更多

$23 CAD 在1天内
(0条评论)
0.0

3 威客就此工作平均出价 $19

kelvinm094

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 更多

$20CAD 在1天里
(1条评论)
1.6
khansajol082

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.

$13CAD 在1天里
(0条评论)
0.0