Find Jobs
Hire Freelancers

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
Project ID: 17736276

About the project

3 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
User Avatar
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.
$20 CAD in 1 day
5.0 (1 review)
1.6
1.6
User Avatar
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.
$13 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Toronto, Canada
0.0
0
Member since Sep 9, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.