Deleting Dates

L

Legolas26

New Member
Joined
Sep 19, 2003
Messages
3
Okay, I have two different columns of data on the same worksheet, organized by date. I'm trying to match up dates and times together(this is well data, matching up two different wells measured on the same day). Some days one well was dry so my dates don't always match up, and I'm trying to go through and manually delete the dates that are out of sync. I just have so much data that this is going to take forever. Is there any way that Excel can find dates and times that are the same and match them up? Or any other ideas on how to do this?

Ex. 8/8/02 11:30|8/7/02 17:00
8/8/02 12:00|8/8/02 11:30

So those would be the columns and I want to match up 8/8/02 11:30 with 8/8/02 11:30. The columns aren't actually beside each other though, there's actual data in between, if it helps they are in rows A and E.
THANKS! :biggrin:
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
When you say match them up, what do you mean? Are you trying to rearrange them?
 
Upvote 0
Can you post some data using Colo's utility (linked at the bottom of the page)?
 
Upvote 0
I'm trying to go through and delete the ones that don't go together. They are entered as they were measured, and what happened is that sometimes there wasn't any data for one, so its column has less data than the other one and the dates don't match. I want to delete the extra dates so that all is left are measurements for the same days at the same times. Do you see what I'm saying?
 
Upvote 0
You need a VBA macro to loop through the column, do comparisons and shift the cells up when a bogus value is found. This would take a bit of effort to write; not a two-minute answer. I assume either column could fall ahead or behind.
 
Upvote 0
Stick your s/s up on the board (if you can) and we (the board members) may be able to consttruct a macro or xl solution
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Convert American date and time into Australian date and time
Replies
6
Views
837
barto1973
B
T
  • Solved
Excel Time increment
Replies
9
Views
301
awoohaw
awoohaw
O
  • Solved
american/australian dates
Replies
6
Views
247
Alex Blakenburg
A
S
  • Solved
Conditional format dates in a range which are x days from today
Replies
3
Views
460
Sallyprit
S
W
  • Solved
Validate month based on contract dates & Calculate number of weeks in that month to calculate hours booked per month
2
Replies
16
Views
1K
phiero21
P

Forum statistics

Threads
1,215,062
Messages
6,122,923
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top