TinaP
Well-known Member
- Joined
- Jan 26, 2005
- Messages
- 528
I have the following list:
I need formulas that will return the names of anyone who has a number >3 in any month and/or a total >=8 in any rolling 3 month period. In this instance, the formulas would return:
Emma (>3)
Grace (>3)
Harry (>=8)
I'd like to avoid VBA, if possible. I figure this could be done with an array formula, but I need more education to tackle one.
Excel 2010 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | MONTH | Chuck | David | Emma | Fred | Grace | Harry | ||
2 | Jan | 1 | 2 | 3 | 1 | 5 | 3 | ||
3 | Feb | 0 | 0 | 0 | 0 | 0 | 4 | ||
4 | Mar | 0 | 1 | 0 | 0 | 0 | 2 | ||
5 | Apr | 0 | 0 | 0 | 0 | 1 | 0 | ||
6 | May | 0 | 0 | 0 | 0 | 0 | 0 | ||
7 | Jun | 0 | 0 | 1 | 0 | 0 | 0 | ||
8 | Jul | 2 | 0 | 0 | 0 | 1 | 0 | ||
9 | Aug | 0 | 0 | 0 | 0 | 0 | 0 | ||
10 | Sep | 0 | 0 | 0 | 2 | 0 | 0 | ||
11 | Oct | 0 | 1 | 0 | 0 | 0 | 1 | ||
12 | Nov | 0 | 0 | 0 | 0 | 0 | 0 | ||
13 | Dec | 0 | 0 | 0 | 0 | 0 | 0 | ||
Sheet1 |
I need formulas that will return the names of anyone who has a number >3 in any month and/or a total >=8 in any rolling 3 month period. In this instance, the formulas would return:
Emma (>3)
Grace (>3)
Harry (>=8)
I'd like to avoid VBA, if possible. I figure this could be done with an array formula, but I need more education to tackle one.