Find Jobs
Hire Freelancers

Help! Filter My Excel File

$30-100 USD

Closed
Posted almost 20 years ago

$30-100 USD

Paid on delivery
I have an excel file with approximately 65000 rows and 2 columns. Column A contains an invoice number and does not need to be modified. Column B contains a text description of the invoice. The text description for some invoices contains a 5-digit ticket number. Not all text descriptions contain a ticket number. There is a small XLS file attached containng a sample set of 20 records. I need to filter the excel file data so it only contains two columns. Column A should be the invoice number and column B should be the ticket number. Any records that do not contain a ticket number should be excluded from the set. I hope this makes sense. Thanks! ## Deliverables A flat text or excel file containing the data resulting from the filter described in the above description. ## Platform Any
Project ID: 3276144

About the project

1 proposal
Remote project
Active 20 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
1 freelancer is bidding on average $30 USD for this job
User Avatar
See private message.
$29.75 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Oakland, United States
5.0
95
Payment method verified
Member since Oct 30, 2002

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.