Sort by date Macro [Closed]

Report
Posts
3
Registration date
Monday November 2, 2009
Status
Member
Last seen
November 3, 2009
-
 Blocked Profile -
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 reply


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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!