LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 104
Default COUNTING 3 DIFFERENT TYPES OF DATA FROM A RANGE

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
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
Counting word types in a cell Wes_SA Excel Worksheet Functions 2 September 27th 09 07:45 AM
Counting data in a range Glenn L. Excel Worksheet Functions 7 July 14th 08 06:01 PM
Counting different workinghour types Wanderer Excel Worksheet Functions 2 April 1st 07 08:22 PM
Counting the number of Error Types Bob Excel Worksheet Functions 3 November 16th 06 06:01 PM
Counting data in a range Stuart Excel Discussion (Misc queries) 4 July 12th 05 09:44 PM


All times are GMT +1. The time now is 03:20 PM.

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"