Find Jobs
Hire Freelancers

Combine Data from Two Columns

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I've got a list of 10k links (list A) and another list of 10k+ links (list B). Request 1 - I need a new column created with all the links that are exclusively on List A. Request 2 - I also need all the links that are on List A that are also on List B only if they're flagged in Column B (List B) as either “(Blanks)” or “no link” - in which case I'd need those links in a new column followed by their Column B (List B) status in a new column. I can explain better or offer an example if needed. Should be easy to do with a MATCH formula and VLOOKUP - but the logic is tricking me and I can't nail it down. I need a pro!
Project ID: 6231506

About the project

17 proposals
Remote project
Active 10 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
Hi, If MATCH and VLOOKUP doesn't work I can write a code in VBA. I am an excel & VBA expert. Contact me for more informations please. This job will take me 1 hour. Waiting with interest your response. Thank you!
$30 USD in 0 day
4.9 (7 reviews)
2.8
2.8
17 freelancers are bidding on average $69 USD for this job
User Avatar
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$50 USD in 0 day
4.9 (204 reviews)
6.9
6.9
User Avatar
A proposal has not yet been provided
$147 USD in 3 days
4.8 (81 reviews)
6.1
6.1
User Avatar
Dear, I ll code a VBA macro using Vlookup to generate these new columns accoroding to the criteria you mentionned. Also I ll provide the code so you can use it for further files. Ready to start and to finish in 2-3 hours from now. Thanks
$35 USD in 3 days
4.9 (56 reviews)
5.6
5.6
User Avatar
Dear Sir, quality and expert researcher here to search a targeted group of people, images, email addresses, database or anything that you are needed you may hire me in full confidence.
$155 USD in 3 days
4.8 (21 reviews)
4.8
4.8
User Avatar
Hey, I am an excel expert and can handle anything using excel. This is a very easy project and I dont think you should be paying for that. I usually help for similar projects on different forums for free. The only difference is that when you post on forum, it takes you a day or two to get a reply. Just send me the file and I can do that free for you. Let me see the data so I can tell if it can be done by a custom formula or one from the standard library. Can do it free for you and pay me in future if you have a big project. Dont waste your money here.
$30 USD in 3 days
5.0 (23 reviews)
4.3
4.3
User Avatar
Hi. I can work on this for you immediately, but will take a different approach than directly in Excel. I will import both lists into access and do a couple queries and then export the relevant data back to excel. I will also send you my access DB if you require. When you Hire me, you'll be hiring a professional with 10+ years in the IT industry and two Microsoft Certificates. Please see my feedback/profile right here on Freelancer, a testimony to my excellent work and professional approach. All customers are 100% satisfied. Looking forward to helping you on this, and building a working relationship toward the future. Kind Regards, Kenny. P.S. I'm from the Caribbean so there's no language barrier and our time zones should be close as well.
$44 USD in 1 day
5.0 (6 reviews)
3.7
3.7
User Avatar
Dear Employer, We are dedicated freelancers from India, with experience in excel (kindly refer to the reviews we got so far). We have addressed similar kind of project and we can do this one also. Kindly message us spread sheets. We can sort it as per your requirements. Look forward for a message from you and a chance to serve you. Thank you.
$35 USD in 0 day
5.0 (8 reviews)
2.6
2.6
User Avatar
Hello. Excel actually uses vba, I use actual vb which is the language of vba scrpit. I can fix this with vb. However I won't give you any formula or type to put in your excel, just the data as you want them. Please message me if you need more info. Regards, Marina Louki
$30 USD in 1 day
4.9 (7 reviews)
2.4
2.4
User Avatar
Hello Sir, Can solve the script provide the file version as required. Thanks and regards, Mustafa
$74 USD in 2 days
5.0 (4 reviews)
2.0
2.0
User Avatar
Hi, I have done so many jobs related to EXCEL. I will be able to do this. kindly send me the SHEET. Kindly allocate this project to me and i have many ideas related to the above functionality and if i got this project i will assure you that i will complete it on time and with quality work.
$45 USD in 0 day
5.0 (1 review)
1.7
1.7
User Avatar
I'm new to freelancer.com so would gladly do this job for a low price to learn the system. Think your project of combining data is doable (but, like you said, tricky). my experience developing advanced budget systems makes me feel comfortable with this. Thanks.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can make it in 1 day, almost for free, please give a chance to a new entry, I will not disappoint you, thanks
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a person with the good skills in Excel and they have to do this task with good accuracy and effectiveness. We are sure to complete this proposal in a time duration. Thank you ! We trust your efforts. Kind Regards, Nirav Parmar Manager (NP Outsourcing Service)
$122 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Oceanside, United States
5.0
1
Payment method verified
Member since Jul 24, 2014

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.