I am trying to run a trimmean function on a set of data, and it needs to be based on multiple input items,
The raw data has an average range, and 3 columns for criteria matching (Month, and two more group fields Match1 and Match2).
I am unable to get this to work, even using an array formula and CTRL SHIFT ENTER.
I would like to use trimmean to remove 10% of the outlying record set.
ANy advice?
I attached a sample sheet.
The formula i have now is =TRIMMEAN(IF(team=$A2,range,IF(month=B$1,range)),10%)
Summary sheet:
Team Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A 1.643406593
B 1.643406593
C 1.643406593
D
E
F
G
Detail:
Range Month Match Match2
0.20 Jan A 1
0.83 May B 2
1.17 Mar C 3
0.45 Mar D 1
0.92 Mar E 2
0.02 Sep F 3
0.47 Jan G 1
0.33 Mar A 2
0.40 Mar B 3
0.62 Mar C 1
3.57 Apr D 2
0.42 Mar E 3
1.15 Mar F 1
Bookmarks