WhiteNoiseMaker
New Member
- Joined
- Jan 23, 2015
- Messages
- 23
My first post and I’m desperately in need of help!
I have a list of dates running from 01/01/2015 to 31/12/2015 in column A. This is followed by the task performed that day, and how much has been processed e.g.
A | B | C |
05/01/2015 | Project 1 | 100 |
06/01/2015 | Project 1 | 150 |
07/01/2015 | Project 1 | 90 |
08/01/2015 | Project 2 | 50 |
09/01/2015 | Project 2 | 60 |
10/01/2015 | ||
11/01/2015 |
<tbody>
</tbody>
I need to be able to count the most common task performed for each week. In the example above the answer I would expect is Project 1, as the majority of the week was spent working on this project.
The example I’ve found below works but I need to specify the date range I want to check, which is too time consuming.
=INDEX(B16:B22,MATCH(MAX(COUNTIF(B16:B22,B16:B22)),COUNTIF(B16:B22,B16:B22),0))
I’m trying to combine the formula above with a formula i have working for counting the totals for each week but I just can’t get it to work.
=SUMIFS($C$16:$C$406,$A$16:$A$406,">="&$O3,$A$16:$A$406,"<="&$O3+6) (O3 contains my list of Monday dates)
Any help would be greatly appreciated