REVscene Automotive Forum - View Single Post

TRDood · 03-21-2011, 07:20 PM

I am trying to match 2 columns together, basically I want to merge 2 data sets together but they have different dates.

e.g.

1/22/2007 6.633 Jan 22, 2007 51.11
1/23/2007 6.6193 Jan 23, 2007 53.61
1/24/2007 6.5801 Jan 24, 2007 54.24
1/25/2007 6.582 Jan 25, 2007 53.49
1/26/2007 6.593 Jan 26, 2007 55.38
1/27/2007 6.5789 Jan 29, 2007 54.01
1/28/2007 6.5916 Jan 30, 2007 57.03
1/29/2007 6.5918 Jan 31, 2007 58.17
1/30/2007 6.5824 Feb 01, 2007 57.35
1/31/2007 6.577 Feb 02, 2007 59.01
2/1/2007 6.587 Feb 05, 2007 58.69

I have to delete the bolded ones so that the 2 columns match, similar to this...

http://www.eggheadcafe.com/software/...reference.aspx

Thanks!

Looking for simple excel solutions, not VBA... I have about 1200 data points, it will take me hours to delete all the weekends.

03-21-2011, 07:20 PM	#1
TRDood I answer every Emotion with an emoticon Join Date: Jul 2006 Location: V Posts: 7,849 Thanked 656 Times in 326 Posts Failed 190 Times in 91 Posts	Excel Gurus please help I am trying to match 2 columns together, basically I want to merge 2 data sets together but they have different dates. e.g. 1/22/2007 6.633 Jan 22, 2007 51.11 1/23/2007 6.6193 Jan 23, 2007 53.61 1/24/2007 6.5801 Jan 24, 2007 54.24 1/25/2007 6.582 Jan 25, 2007 53.49 1/26/2007 6.593 Jan 26, 2007 55.38 1/27/2007 6.5789 Jan 29, 2007 54.01 1/28/2007 6.5916 Jan 30, 2007 57.03 1/29/2007 6.5918 Jan 31, 2007 58.17 1/30/2007 6.5824 Feb 01, 2007 57.35 1/31/2007 6.577 Feb 02, 2007 59.01 2/1/2007 6.587 Feb 05, 2007 58.69 I have to delete the bolded ones so that the 2 columns match, similar to this... http://www.eggheadcafe.com/software/...reference.aspx Thanks! Looking for simple excel solutions, not VBA... I have about 1200 data points, it will take me hours to delete all the weekends.