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

I përfunduar
Postuar over 5 years ago

$10-30 CAD

Paguhet në dorëzim
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
ID e Projektit: 17736276

Rreth projektit

3 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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 në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
3 freelancers are bidding on average $19 CAD for this job
Avatari i Përdoruesit
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 në 1 ditë
5,0 (1 review)
1,6
1,6
Avatari i Përdoruesit
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 në 1 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i CANADA
Toronto, Canada
0,0
0
Anëtar që nga sht 9, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.