LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Werner Rohrmoser
 
Posts: n/a
Default Counting with Array Formula

Hello,

below you can see a table devided in months and weeks.
In every week there can occur an event, here called "A".

Question:
How can I count in how many months an event happens.
Result for table below is 2, in Jan and in Mar.

Jan Jan Jan Jan Feb Feb Feb Feb Mar Mar Mar Mar
wk1 wk2 wk3 wk4 wk5 wk6 wk7 wk8 wk9 wk10 wk11 wk12
A A A A

Thanks for your support.

Regards
Werner

 
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
array formula Jonathan Cooper Excel Discussion (Misc queries) 4 September 9th 05 12:27 PM
#VALUE! On An Array Formula Referencing a Range Outside The Workbo paige Excel Discussion (Misc queries) 5 September 9th 05 12:05 AM
Array Formula help pls. klam Excel Worksheet Functions 4 August 24th 05 04:05 PM
Array Formula Karen Excel Worksheet Functions 2 June 7th 05 06:49 PM
Help with array formula Excel Worksheet Functions 2 January 20th 05 04:17 PM


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"