Find Jobs
Hire Freelancers

Advanced Excel / VBA formula - Search 2 criteria using CONTAINS

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 6873258

About the project

17 proposals
Remote project
Active 9 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
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 in 0 day
4.9 (175 reviews)
6.6
6.6
17 freelancers are bidding on average $31 USD for this job
User Avatar
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 in 1 day
4.9 (270 reviews)
7.8
7.8
User Avatar
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 in 0 day
5.0 (330 reviews)
7.4
7.4
User Avatar
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 in 0 day
5.0 (186 reviews)
7.4
7.4
User Avatar
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 in 0 day
4.9 (257 reviews)
7.7
7.7
User Avatar
A proposal has not yet been provided
$50 USD in 1 day
5.0 (202 reviews)
7.4
7.4
User Avatar
i can do it for you quickly and exactly .
$111 USD in 2 days
4.9 (135 reviews)
7.2
7.2
User Avatar
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 in 0 day
4.9 (95 reviews)
6.6
6.6
User Avatar
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 in 0 day
4.9 (61 reviews)
5.5
5.5
User Avatar
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 in 0 day
5.0 (54 reviews)
4.7
4.7
User Avatar
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 in 1 day
5.0 (3 reviews)
2.6
2.6
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Bournemouth, United Kingdom
5.0
51
Payment method verified
Member since May 7, 2008

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.