Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone have any suggestions on how to determine the date?
There is a list of date under column A, and a given number 3 in cell B1 I would like to determine the highest occurrence +/- 3 days If I select the date 11-Jan-08, the range will be between 8-Jan-08 and 14-Jan-08. For the occurrence on 11--Jan-08, it should return 2 in cell C1. Does anyone have any suggestions on how to determine the highest occurrence? Thanks in advance for any suggestions Eric 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 .... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to determine the occurrence between periods? | Excel Discussion (Misc queries) | |||
How to find out the 3 highest occurrence of number from a list? | Excel Discussion (Misc queries) | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
How to determine second (and then third) highest value in a list | Excel Discussion (Misc queries) | |||
How to determine second (and then third) highest value in a list | Excel Discussion (Misc queries) |