I need every rows date to match the date in Column A. Column A (Date) Column B (In) Column C (Out) must remain together because the in/out numbers are for a that date/time.
For instance, A7 shows 2/17/2013 1:32. You can see D7 (2/17/2013 1:37) does not match A7. Because of this I need excel to 'push' this cell (D7) down so (2/17/2013 1:37) will now be D8 therefore matching A8. BTW I have about 10,000 rows so doing it by hand is not possible without giving up the Colbert Report.
Thank you in advance for your helpful suggestions!
1 Date In Out Date In Out Date In Out Date In Out
2 2/17/2013 0:02 34 165 2/17/2013 0:02 34 165 2/17/2013 0:02 34 165 2/17/2013 0:02 34 165
3 2/17/2013 0:12 34 165 2/17/2013 0:12 34 165 2/17/2013 0:12 34 165 2/17/2013 0:12 34 165
4 2/17/2013 0:37 34 162 2/17/2013 0:42 34 162 2/17/2013 0:37 34 162 2/17/2013 0:37 34 162
5 2/17/2013 0:52 34 166 2/17/2013 0:57 34 166 2/17/2013 0:52 34 165 2/17/2013 0:52 34 166
6 2/17/2013 1:07 34 165 2/17/2013 1:12 34 165 2/17/2013 1:07 34 166 2/17/2013 1:07 34 165
7 2/17/2013 1:32 34 165 2/17/2013 1:37 34 165 2/17/2013 1:32 34 165 2/17/2013 1:42 34 165
8 2/17/2013 1:37 34 165 2/17/2013 1:47 34 165 2/17/2013 1:47 34 165 2/17/2013 1:47 34 165
For instance, A7 shows 2/17/2013 1:32. You can see D7 (2/17/2013 1:37) does not match A7. Because of this I need excel to 'push' this cell (D7) down so (2/17/2013 1:37) will now be D8 therefore matching A8. BTW I have about 10,000 rows so doing it by hand is not possible without giving up the Colbert Report.
Thank you in advance for your helpful suggestions!
1 Date In Out Date In Out Date In Out Date In Out
2 2/17/2013 0:02 34 165 2/17/2013 0:02 34 165 2/17/2013 0:02 34 165 2/17/2013 0:02 34 165
3 2/17/2013 0:12 34 165 2/17/2013 0:12 34 165 2/17/2013 0:12 34 165 2/17/2013 0:12 34 165
4 2/17/2013 0:37 34 162 2/17/2013 0:42 34 162 2/17/2013 0:37 34 162 2/17/2013 0:37 34 162
5 2/17/2013 0:52 34 166 2/17/2013 0:57 34 166 2/17/2013 0:52 34 165 2/17/2013 0:52 34 166
6 2/17/2013 1:07 34 165 2/17/2013 1:12 34 165 2/17/2013 1:07 34 166 2/17/2013 1:07 34 165
7 2/17/2013 1:32 34 165 2/17/2013 1:37 34 165 2/17/2013 1:32 34 165 2/17/2013 1:42 34 165
8 2/17/2013 1:37 34 165 2/17/2013 1:47 34 165 2/17/2013 1:47 34 165 2/17/2013 1:47 34 165