Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the frequency?
[Re-word my post]
Does anyone have any suggestions on how to determine the frequency? There is a list of date under column A, and a given number 3 in cell B1 I would like to determine the frequency with +/- 3 days acceptable range 04-Jan-09, 09-Jan-09, 11-Jan-09, 18-Jan-09, 20-Jan-09, 22-Jan-09, 23-Jan-09, 24-Jan-09, 24-Jan-09, 24-Jan-09, 24-Jan-09, 26-Jan-09, 27-Jan-09, 05-Feb-09, 06-Feb-09, 12-Feb-09, 17-Feb-09 ... On 4-Jan-08, it should return 1 in cell C1 for range between 1-Jan-09 and 7-Jan-09, which include 04-Jan-09 only. On 09-Jan-08, it should return 2 in cell C3 for range between 5-Jan-09 and 12-Jan-09, which include 09-Jan-09 and 11-Jan-09. On 11-Jan-08, it should return 2 in cell C3 for range between 8-Jan-09 and 14-Jan-09, which include 09-Jan-09 and 11-Jan-09. .... On 24-Jan-08, it should return 8 in cell C8 for range between 21-Jan-09 and 27-Jan-09, which include 22-Jan-09, 23-Jan-09, 24-Jan-09, 24-Jan-09, 24-Jan-09, 24-Jan-09, 26-Jan-09, 27-Jan-09 Does anyone have any suggestions on how to determine the occurrence? Thanks in advance for any suggestions Eric |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to I determine frequency | Excel Worksheet Functions | |||
Frequency.... I think | Excel Worksheet Functions | |||
How to determine the frequency of a list of numbers? | Excel Discussion (Misc queries) | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
Determine Frequency in Filtered List | Excel Worksheet Functions |