Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to count the number of occurrence within string? | Excel Discussion (Misc queries) | |||
How to count the occurrence? | Excel Discussion (Misc queries) | |||
How to count occurrence? | Excel Discussion (Misc queries) | |||
count occurrence between two specific dates | Excel Discussion (Misc queries) | |||
Count occurrence of character within a cell | Excel Discussion (Misc queries) |