Search : in
By :

Sort by date Macro

Last answer on Nov 4, 2009 11:41:45 am GMT Tyagus, on Nov 3, 2009 4:05:41 pm GMT 
 Report this message to moderators

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.

Configuration: Windows XP
Firefox 3.5.4

Best answers for « Sort by date Macro » in :
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
Ask your question Reply

1

 LouisSteph, on Nov 4, 2009 11:41:45 am GMT

Dear Tyagus,

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

http://en.kioskea.net/forum/affich-90547-excel-formatting-an­d-sorting-dates

Thanks.

   
Reply to LouisSteph
Ask your question Reply
They need your help