LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Question: How many occurences in date range?

Good afternoon

Col A has a list of dates and times. The data looks like this:
08/09/09 08:12
08/09/09 09:15
08/10/09 07:59.. etc.

Each date/time represents one transaction.
We need to count the number of transactions occurring on a each day between
two times. For example, on 8/09/09 between 8:00 and 9:59 the answer would be
2.

Can you give me some ideas about how to approach this problem? We don't
want to script this, but will use a separate cell on a sheet for each date
and time range.

Thanks in advance for your help.
-DL
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count number of occurences within a time range [email protected] Excel Discussion (Misc queries) 9 January 20th 13 05:54 PM
SUMPRODUCT to find occurences within date range WildWill Excel Discussion (Misc queries) 11 April 19th 09 06:55 PM
How to count the occurences in my range with 2 characters only? Jen[_4_] Excel Worksheet Functions 5 June 27th 07 09:30 AM
counting occurences in data range (e.g 31-60) Chuck Excel Worksheet Functions 2 June 28th 06 02:09 PM
How do I count occurences in a date range? Jeremy Excel Worksheet Functions 2 July 8th 05 11:21 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"