Sort by date Macro

Closed
Tyagus Posts 3 Registration date Monday 2 November 2009 Status Member Last seen 3 November 2009 - 3 Nov 2009 à 11:05
 Blocked Profile - 4 Nov 2009 à 06:41
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
4 Nov 2009 à 06:41
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.