EXCEL 2007. Time, date, load fields. I have entered data for every hour, 24 rows per day. I can sort on date field, nice line up, all 24 rows for 1st date, 24 rows for 2nd day, etc... Now when I sort on time, in order to see 1st hour's data for each date, I get screwy data. Just using sort command, oldest to newest on time. First time rows all in order (12:30 AM for all 30 days), but 2nd (1:30 AM) drops 11/6 row down towards end of this time periods listing. Does same for 11/18. Does the same through out the month's worth of data. See example below.
<tbody>
</tbody>
Verified formatting of both columns is correct. Tried cutting & inserting the 6th's row into proper position, then resorted, still drops as shown.
Can anyone tell me why, and how to correct it?
Thanks
Rick
12:30:00 AM | 11/1/2007 | 4500 |
12:30:00 AM | 11/2/2007 | 5000 |
12:30:00 AM | 11/3/2007 | 4900 |
12:30:00 AM | 11/4/2007 | 4300 |
12:30:00 AM | 11/5/2007 | 4000 |
12:30:00 AM | 11/6/2007 | 5400 |
12:30:00 AM | 11/7/2007 | 5000 |
12:30:00 AM | 11/8/2007 | 4700 |
12:30:00 AM | 11/9/2007 | 4600 |
12:30:00 AM | 11/10/2007 | 4500 |
12:30:00 AM | 11/11/2007 | 4000 |
12:30:00 AM | 11/12/2007 | 3800 |
12:30:00 AM | 11/13/2007 | 5100 |
12:30:00 AM | 11/14/2007 | 5000 |
12:30:00 AM | 11/15/2007 | 5200 |
12:30:00 AM | 11/16/2007 | 5000 |
12:30:00 AM | 11/17/2007 | 5100 |
12:30:00 AM | 11/18/2007 | 4200 |
12:30:00 AM | 11/19/2007 | 4000 |
12:30:00 AM | 11/20/2007 | 5000 |
12:30:00 AM | 11/21/2007 | 5500 |
12:30:00 AM | 11/22/2007 | 4700 |
12:30:00 AM | 11/23/2007 | 4200 |
12:30:00 AM | 11/24/2007 | 4300 |
12:30:00 AM | 11/25/2007 | 4600 |
12:30:00 AM | 11/26/2007 | 4300 |
12:30:00 AM | 11/27/2007 | 4800 |
12:30:00 AM | 11/28/2007 | 4500 |
12:30:00 AM | 11/29/2007 | 4800 |
12:30:00 AM | 11/30/2007 | 5000 |
1:30:00 AM | 11/1/2007 | 4100 |
1:30:00 AM | 11/2/2007 | 4300 |
1:30:00 AM | 11/3/2007 | 4300 |
1:30:00 AM | 11/4/2007 | 3800 |
1:30:00 AM | 11/5/2007 | 3500 |
1:30:00 AM | 11/7/2007 | 4400 |
1:30:00 AM | 11/8/2007 | 4300 |
1:30:00 AM | 11/9/2007 | 4200 |
1:30:00 AM | 11/10/2007 | 4100 |
1:30:00 AM | 11/11/2007 | 3800 |
1:30:00 AM | 11/12/2007 | 3500 |
1:30:00 AM | 11/13/2007 | 4400 |
1:30:00 AM | 11/14/2007 | 4200 |
1:30:00 AM | 11/15/2007 | 4400 |
1:30:00 AM | 11/16/2007 | 4400 |
1:30:00 AM | 11/17/2007 | 3800 |
1:30:00 AM | 11/19/2007 | 3800 |
1:30:00 AM | 11/20/2007 | 4200 |
1:30:00 AM | 11/21/2007 | 5000 |
1:30:00 AM | 11/22/2007 | 4200 |
1:30:00 AM | 11/23/2007 | 4000 |
1:30:00 AM | 11/24/2007 | 4400 |
1:30:00 AM | 11/25/2007 | 4500 |
1:30:00 AM | 11/26/2007 | 4200 |
1:30:00 AM | 11/27/2007 | 4400 |
1:30:00 AM | 11/28/2007 | 5000 |
1:30:00 AM | 11/29/2007 | 4900 |
1:30:00 AM | 11/6/2007 | 4500 |
1:30:00 AM | 11/18/2007 | 3900 |
1:30:00 AM | 11/30/2007 | 4800 |
<tbody>
</tbody>
Verified formatting of both columns is correct. Tried cutting & inserting the 6th's row into proper position, then resorted, still drops as shown.
Can anyone tell me why, and how to correct it?
Thanks
Rick