LFMN | 0.0826 |
LFMN | 0.0834 |
LFMN | 0.0829 |
LFMN | 0.0826 |
LFMN | 0.0834 |
LFMN | 0.1305 |
LFMN | 0.3058 |
LFMN | 0.0452 |
LFMN | 0.2625 |
LFMN | 0.2640 |
LFMN | 0.6166 |
LFMN | 0.2887 |
LFMN | 0.0853 |
LFMN | - |
LFMN | 0.0792 |
LFMN | 0.0854 |
LFMN | 0.0386 |
LFMN | 0.4018 |
LFMN | 0.0853 |
Excel 2010 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
8 | Helper | ||||||
9 | LFMN | 0.0826 | 0.153038 | 1 | |||
10 | LFMN | 0.0834 | 0.153038 | 1 | |||
11 | LFMN | 0.0829 | 1 | ||||
12 | LFMN | 0.0826 | 1 | ||||
13 | LFMN | 0.0834 | 1 | ||||
14 | LFMN | 0.1305 | 1 | ||||
15 | LFMN | 0.3058 | 1 | ||||
16 | LFMN | 0.0452 | 1 | ||||
17 | LFMN | 0.2625 | 1 | ||||
18 | LFMN | 0.264 | 1 | ||||
19 | LFMN | 0.6166 | 1 | ||||
20 | LFMN | 0.2887 | 1 | ||||
21 | LFMN | 0.0853 | 1 | ||||
22 | LFMN | 0 | 0 | ||||
23 | LFMN | 0.0792 | 1 | ||||
24 | LFMN | 0.0854 | 1 | ||||
25 | LFMN | 0.0386 | 1 | ||||
26 | LFMN | 0.4018 | 1 | ||||
27 | LFMN | 0.0853 | 1 | ||||
28 | |||||||
8a |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E9 | =(A9=A9)*(B9<>0) | |
C9 | {=TRIMMEAN(IF((A9:A50=A9)*(B9:B50<>0),B9:B50),0.15)} | |
C10 | {=TRIMMEAN(IF((E9:E50=1),B9:B50),0.15)} | |
Press CTRL+SHIFT+ENTER to enter array formulas. |