In Corso

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

Competenze: Elaborazione dati, Programmazione Database, Excel, Visual Basic

Vedere di più: 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

Sul datore di lavoro:
( 0 valutazioni ) Toronto, Canada

ID Progetto: #17736278

Assegnato a:

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 in 1 giorno
(0 valutazioni)
0.0

3 freelance hanno fatto un'offerta media di $25 per questo lavoro

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 Più

$25 CAD in 1 giorno
(15 Recensioni)
3.8
$25 CAD in 1 giorno
(0 Recensioni)
0.0