Find Jobs
Hire Freelancers

Advanced Excel / VBA formula - Search 2 criteria using CONTAINS

$10-30 USD

Terminado
Publicado hace más de 9 años

$10-30 USD

Pagado a la entrega
VBA task. I have a csv list of input data with 3 fields - postcode + surname + telephone. I have an output list containing postcodes and surnames only. Take each postcode surname pair from output list and where the input list contains postcode and contains surname, put the telephone number in the output. Input file is a million records. Suggest in each instance you build a list of matching postcodes then search this list for the matching name. Small project. Must be completed in the next few hours. If you don't explain that you can do this project and just provide a generic covering message you will be ignored. Thanks.
ID del proyecto: 6873258

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 9 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
Hey There, We can make the combination of post codes and surname to be the composite key and find it from the input file. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$29 USD en 0 día
4,9 (175 comentarios)
6,6
6,6
17 freelancers están ofertando un promedio de $31 USD por este trabajo
Avatar del usuario
Dear Hiring Manager, I am writing in response to your advertisement for a “Data Entry Assistant ”. After carefully reviewing the experience requirements of the job description, I feel that I am perfect for this job. I have done lots of data entry work such as inputting customer requests, inquire, tracking codes of products and price of products, scrap data from different types of web site, collect emails & enter them into excel, etc and so on. I also perform administrative duties including copying and faxing documents, transferring data, web research and reports to immediate supervisor. I have extensive knowledge of using MS programs such as Spreadsheets, PowerPoint, Excel, data scraping and Word along with a number of other software and programs. I also possess extensive knowledge of database programs. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your company, the requirements of the position, and how my qualifications would be a good fit. Sincerely, Motiur .
$25 USD en 1 día
4,9 (270 comentarios)
7,8
7,8
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, databases and complex macros and formulas to process the information. According to what you say is a project to vlookup formula, the advantage of applying VBA there is no need to copy the formula for each cell, if there are 1 million of them. Check my reviews and chat with me. My ratings speak for themselves. Greetings.
$27 USD en 0 día
5,0 (330 comentarios)
7,4
7,4
Avatar del usuario
Hello, I am very much interested to do this work by vb.net. As i did similar type of works by it, i think i can do this easily & efficiently. Please let me know if you are interested. Note: My approach will be to load the input & output list and get the telephone number from input by postcode + surname. Thanks
$22 USD en 0 día
5,0 (186 comentarios)
7,4
7,4
Avatar del usuario
Hi, I'll be happy to help you with this project. I will start on it right away and should be able to complete it within an hour
$40 USD en 0 día
4,9 (257 comentarios)
7,7
7,7
Avatar del usuario
A proposal has not yet been provided
$50 USD en 1 día
5,0 (202 comentarios)
7,4
7,4
Avatar del usuario
i can do it for you quickly and exactly .
$111 USD en 2 días
4,9 (135 comentarios)
7,2
7,2
Avatar del usuario
Hi I would love to work on this project. I have 5 years of experience in Microsoft Excel. Please contact with further details if interested. Regards Raghav Bansal
$24 USD en 0 día
4,9 (95 comentarios)
6,6
6,6
Avatar del usuario
Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: ü Expert on C# using .NET framework using Visual Studio 2012 and 2013 ü Expert in VB.NET using VS2012/VS2013 ü WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$30 USD en 0 día
4,9 (61 comentarios)
5,5
5,5
Avatar del usuario
Greetings for the Day!!! i have 5 years of experience in Data entry and typing , Excel macro, VB script and VB application creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. the breif of the project is to retrieve details based on surname and postal code,it can be done using vlookups or excel macros snd i can make it in max 1hr as expected hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$25 USD en 0 día
5,0 (54 comentarios)
4,7
4,7
Avatar del usuario
concatenate the postcode and surname in input list. then use vlookup concat of postcode and surname to fetch the telephone number. Remove concatenate field and the vlookup formula once the values are copied Or another simple formula If combination of Surname and Postcode are unique then i will use SUMIFS formula to retrieve the phonenumber if phone number is all number without special characters. If not remove all the special characters of phonenumber and apply the SUMIFS formula. I can complete it in few minutes and give it back to you.
$10 USD en 1 día
5,0 (3 comentarios)
2,6
2,6
Avatar del usuario
Hello! I can make this task! It takes me 24 hours. Just 15 $. But the time of working for this macro could be more then 1 hour (for such number of records) Best regards Anton Fesenko
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi,If you offered me the job this is what I am planning to do. I will load input list in Excel sheet1 and output at sheet 2 and using EXCEL VBA function i'll match the sheet 2 content with sheet1 and extract the telephone and place it in sheet2. I have good experience with EXCEL VBA functions.
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi! I can d it with help of dynamic array, cause there are so many rows. It will be done quickly. You can send me sample to test my method. Regards, Khongor
$25 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This project can be completed within few hours using my excellent practical knowledge about MS excel and my high analytical skill. Can use advance conditional formulas, functions & macro programming for finish this task easily. Job will be completed within few hours and appreciate if you selected a new freelancer like me for this project. Thanks & regards Malik
$20 USD en 0 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Bournemouth, United Kingdom
5,0
51
Forma de pago verificada
Miembro desde may 7, 2008

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.