LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to count the occurrence?

Does anyone have any suggestions on how to count the occurrence?
There is a list of date under m column, I would like to determine the
occurrence fall into following category without concerning the year.
For example, 17/04/06 is equal or large than 10/4/09 and less than 25/4/09,
therefore 1 will be asssigned into 10/04/09 category.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric

26/03/09
10/04/09
25/04/09
10/05/09
26/05/09
10/06/09
26/06/09
12/07/09
28/07/09
12/08/09
28/08/09
12/09/09
27/09/09
13/10/09
28/10/09
13/11/09
27/11/09
12/12/09
26/12/09
10/01/09
25/01/09
09/02/09
24/02/09
10/03/09

 
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
How to count the number of occurrence within string? Eric Excel Discussion (Misc queries) 2 October 12th 08 08:56 AM
How to count the occurrence? Eric Excel Discussion (Misc queries) 3 August 11th 08 01:31 AM
How to count occurrence? Eric Excel Discussion (Misc queries) 1 July 12th 07 05:47 AM
count occurrence between two specific dates AzMan Excel Discussion (Misc queries) 1 April 25th 07 07:52 PM
Count occurrence of character within a cell Kelli Excel Discussion (Misc queries) 2 January 18th 06 02:20 PM


All times are GMT +1. The time now is 03:08 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"