Sort by date Macro

Closed
Tyagus Posts 3 Registration date Monday November 2, 2009 Status Member Last seen November 3, 2009 - Nov 3, 2009 at 11:05 AM
 Blocked Profile - Nov 4, 2009 at 06:41 AM
Hello,

I am working in a worksheet that have more than 3000 rows, in one of the columns there is a date in the form of 20-07-2009 10:03:25. I want to filter my data before 10:30, between 10:30 and 11:00 and so on.

After this filter I want to count the number of entries (number of lines, there is no empty cells) according to different criteria and place the results in other sheet.

How can I do this?

Thanks in advance.

1 response

Blocked Profile
Nov 4, 2009 at 06:41 AM
Dear Tyagus,

Please have a look at the thread below and have the matter solved:

https://ccm.net/forum/affich-90547-excel-formatting-and-sorting-dates

Thanks.
0