Find Jobs
Hire Freelancers

Delete redundant Excel Rows (VBA macro)

$30-100 USD

In Progress
Posted about 16 years ago

$30-100 USD

Paid on delivery
Goal: Delete redundant Excel Rows with a Visual Basic Macro program. I have an Excel data file. Often there are redundant rows of data. One of the columns is a time based column. Therefore it is easy to observe if the time is the same from one row to the next. In the case where the time is the same, I want to delete the duplicate, and proceed to the next row(s) until the end of the file is reached, (eg a blank line or cell). I would like to be able to go into the Visual Basic Editor, and make minor changes as necessary, such as change the column on which to examine. I can provide a sample Excel file with redundant entries. I would imagine a simple If (equal) then (delete row) nested in a Do While loop would be all that is needed. ## Deliverables In reviewing writeup, please understand that there may be many redundant (duplicate) rows of data, not just one. So after the first duplicate is found in the 'time' column in this case, then proceed to next row and check for duplicate (time), etc, until you reach the end of the column, which is the last row of data.
Project ID: 3670833

About the project

24 proposals
Remote project
Active 16 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
See private message.
$7 USD in 5 days
4.9 (65 reviews)
4.9
4.9
24 freelancers are bidding on average $25 USD for this job
User Avatar
See private message.
$21.25 USD in 5 days
5.0 (424 reviews)
6.5
6.5
User Avatar
See private message.
$42.50 USD in 5 days
4.9 (89 reviews)
6.1
6.1
User Avatar
See private message.
$17 USD in 5 days
5.0 (120 reviews)
5.6
5.6
User Avatar
See private message.
$42.50 USD in 5 days
5.0 (94 reviews)
5.3
5.3
User Avatar
See private message.
$38.25 USD in 5 days
4.1 (52 reviews)
5.0
5.0
User Avatar
See private message.
$17 USD in 5 days
5.0 (70 reviews)
4.6
4.6
User Avatar
See private message.
$42.50 USD in 5 days
5.0 (15 reviews)
4.6
4.6
User Avatar
See private message.
$34 USD in 5 days
5.0 (7 reviews)
4.6
4.6
User Avatar
See private message.
$21.25 USD in 5 days
4.8 (23 reviews)
4.3
4.3
User Avatar
See private message.
$38.25 USD in 5 days
4.9 (12 reviews)
4.1
4.1
User Avatar
See private message.
$21.25 USD in 5 days
5.0 (31 reviews)
4.1
4.1
User Avatar
See private message.
$42.50 USD in 5 days
5.0 (22 reviews)
3.9
3.9
User Avatar
See private message.
$6.80 USD in 5 days
5.0 (24 reviews)
3.5
3.5
User Avatar
See private message.
$21.25 USD in 5 days
5.0 (5 reviews)
2.8
2.8
User Avatar
See private message.
$5.95 USD in 5 days
5.0 (12 reviews)
2.8
2.8
User Avatar
See private message.
$12.75 USD in 5 days
5.0 (12 reviews)
2.8
2.8
User Avatar
See private message.
$5.95 USD in 5 days
5.0 (18 reviews)
2.7
2.7
User Avatar
See private message.
$17 USD in 5 days
5.0 (3 reviews)
1.8
1.8
User Avatar
See private message.
$8.50 USD in 5 days
5.0 (1 review)
0.0
0.0
User Avatar
See private message.
$80.75 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
4
Member since Jan 28, 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.