Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array formula | Excel Discussion (Misc queries) | |||
#VALUE! On An Array Formula Referencing a Range Outside The Workbo | Excel Discussion (Misc queries) | |||
Array Formula help pls. | Excel Worksheet Functions | |||
Array Formula | Excel Worksheet Functions | |||
Help with array formula | Excel Worksheet Functions |