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 determine the highest occurrence?

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
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 determine the occurrence between periods? Eric Excel Discussion (Misc queries) 1 September 14th 07 04:52 PM
How to find out the 3 highest occurrence of number from a list? Eric Excel Discussion (Misc queries) 5 August 15th 07 04:40 PM
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates John Excel Worksheet Functions 3 August 11th 06 04:34 AM
How to determine second (and then third) highest value in a list Scott M. Lyon Excel Discussion (Misc queries) 2 September 12th 05 11:09 PM
How to determine second (and then third) highest value in a list Scott M. Lyon Excel Discussion (Misc queries) 4 September 12th 05 08:51 PM


All times are GMT +1. The time now is 07:12 AM.

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"