I need an Excel expert to help me find a solution to this problem via a formula or macro
$10-30 CAD
Completed
Posted over 5 years ago
$10-30 CAD
Paid on delivery
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
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. Thanks.
$23 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
3 freelancers are bidding on average $19 CAD for this job
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 Programming, Excel, Visual Basic and so I am accustomed to working with different tasks related to Excel.
I have a deep passion for research and this guarantees you that all of my work is 100% original. I also ensure that I complete the work within the agreed time and a standardized rate.
Please, consider my bid feel free to share more details about your project.
Thank you.