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

Terminado
Publicado hace más de 5 años

$10-30 CAD

Pagado a la entrega
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 del proyecto: 17736276

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
3 freelancers están ofertando un promedio de $19 CAD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
1,6
1,6
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CANADA
Toronto, Canada
0,0
0
Miembro desde sept 9, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.