Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a bit of a tricky one. I have a range of data that i am using
to produce reports. One of these reports relates to column m. This range has various dates in each cell. These dates are in the past and future. What the reports needs to do is identify the first 3 dates in the range that are over todays date and report how many times these dates appear in the range, for instance the range may include feb 12 feb 20 mar 01 mar 01 april 01 april 01 april 10 may 05 may 05 the results would be mar01 = 2 april 01 = 2 april 10 =1 the reports ignores may 05 as its the fourth furthest date in the future hope someone can help as this has me stumpt regards John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting word types in a cell | Excel Worksheet Functions | |||
Counting data in a range | Excel Worksheet Functions | |||
Counting different workinghour types | Excel Worksheet Functions | |||
Counting the number of Error Types | Excel Worksheet Functions | |||
Counting data in a range | Excel Discussion (Misc queries) |