http://www.mrexcel.com/forum/showthread.php?t=481462
Similiar to what the link above did, but I am a total n00b and wouldn't know the first thing about VB Scripting.
So, I have a spreadsheet with 2 years of data. Now I'm being tasked to scrub the data of specific entries. To do this I was given another spreadsheet with only a date/time code like so:
2010/02/26 14:31:31
So far, I've simply been manually comparing date times and deleting the duplicate entries manually. There's over 300 duplicates and it's taking forever.
There has to be a better way. I would even be content with Excel matching them up side by side or highlighting the duplicates with a color so I can CTRL click and delete in one fell swoop.
Dear fellow forum members, can you assist a knuckle head like I in this endevor?
a pic of the current setup.
green fields used to highlight that I've manually matched those two. Once matched, the one on the right will have the whole row deleted.
Similiar to what the link above did, but I am a total n00b and wouldn't know the first thing about VB Scripting.
So, I have a spreadsheet with 2 years of data. Now I'm being tasked to scrub the data of specific entries. To do this I was given another spreadsheet with only a date/time code like so:
2010/02/26 14:31:31
So far, I've simply been manually comparing date times and deleting the duplicate entries manually. There's over 300 duplicates and it's taking forever.
There has to be a better way. I would even be content with Excel matching them up side by side or highlighting the duplicates with a color so I can CTRL click and delete in one fell swoop.
Dear fellow forum members, can you assist a knuckle head like I in this endevor?
a pic of the current setup.
green fields used to highlight that I've manually matched those two. Once matched, the one on the right will have the whole row deleted.
Last edited: