Find Jobs
Hire Freelancers

Excel Compare 2 Columns and align matching data in same row

$30-250 AUD

In Progress
Posted about 11 years ago

$30-250 AUD

Paid on delivery
I have 3 columns of data Column 1 = Product ID (Main) Column 2 = Product ID (Extra) Column 3 = CategoryID Column 1 & 2 = Have the same set of numbers but some are missing from both. I need to compare Column 1 and Column 2 and put a blank row if they don't match. If number from Column 2 does not exist in Column 1, then don't the entire column 2 and column 3 row. Example Column 1 Column 2 Column 3 60 60 1 61 61 1 62 63 63 1 65 72 72 3 Please make sure the when you put a blank row in column 2 that column 3 also follows because Column 2 and Column 3 has to be in the same ROW. If you have questions please let me know, I'm not sure if I explain this correctly. I need this asap if you can show me you can do this today I will accept and pay.
Project ID: 4302336

About the project

8 proposals
Remote project
Active 11 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
I am ready to start work now. Please check Pm for details. Thank You.
$30 AUD in 2 days
4.8 (28 reviews)
4.2
4.2
8 freelancers are bidding on average $56 AUD for this job
User Avatar
Good day! After reading the project description, im confident that i can do this job. I hope you will consider me for this job and i can start immediately. Top data entry provider www.freelancer.com/d/skills/Data_Entry/ Thank You
$69 AUD in 1 day
4.3 (16 reviews)
4.9
4.9
User Avatar
Hi Project understood and ready to go. Will deliver in few hours.
$30 AUD in 1 day
5.0 (11 reviews)
4.2
4.2
User Avatar
I can do this! Could you send me the entire file, so I can adjust my proposal accordingly?
$30 AUD in 1 day
4.9 (6 reviews)
3.0
3.0
User Avatar
Hello sir, Excel and vba expert here, ready to start.
$30 AUD in 1 day
5.0 (7 reviews)
3.0
3.0
User Avatar
Hi... I would like to apply for the job.
$30 AUD in 1 day
5.0 (3 reviews)
2.9
2.9
User Avatar
I have the perfect skill for this project. Further Pl see PM.
$30 AUD in 1 day
5.0 (4 reviews)
2.2
2.2
User Avatar
My team and I have the skills needed to complete this job in a timely and efficient manner. Ready to start today!
$200 AUD in 5 days
5.0 (1 review)
1.4
1.4

About the client

Flag of AUSTRALIA
Stanhope Gardens, Australia
5.0
54
Payment method verified
Member since Jan 29, 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.