counting criteria within alist

J

john.9.williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recognizing Date Ranges in excel 1
total populate date 2
how to set range in excel 1
Finding multiple occurances of a date within one column: Should be easy? 1
Dates to months and calculating values for their months 1
code to find dates 5
Populating Pageheaders Using Vertical Lookups 1
SumProduct or Array Function for summing by month and year 11

Top