gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
Hello,
Can this array be changed to a formula?
Column A: ={IFERROR(INDEX($B$9:$B$20, MATCH(0, COUNTIF($A$24:A24, $B$9:$B$20), 0)),"")}
Thank you!
Can this array be changed to a formula?
Column A: ={IFERROR(INDEX($B$9:$B$20, MATCH(0, COUNTIF($A$24:A24, $B$9:$B$20), 0)),"")}
Thank you!
Options Monster.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
22 | Total +/- per Sector | |||||
23 | Sector | Gain | Stock % | Sector % | ||
24 | Prod Man | $ (3,200.00) | -96.97% | |||
25 | Tech Srvc | $ 11,325.00 | 46.30% | |||
26 | Retail | $ 123,450.00 | 329.60% | |||
27 | Elec Tech | $ 15,550.00 | 126.18% | 71.03% | ||
28 | $ - | |||||
29 | $ - | |||||
30 | $ - | |||||
31 | $ - | |||||
32 | $ - | |||||
33 | Total: | $ 147,125.00 | 101.28% | 71.03% | ||
Options Monster |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A24:A32 | A24 | =IFERROR(INDEX($B$9:$B$20, MATCH(0, COUNTIF($A$24:A24, $B$9:$B$20), 0)),"") |
B24:B32 | B24 | =SUM(SUMIFS($K$9:$K$20,$B$9:$B$20,A24)) |
C24:C32 | C24 | =IFERROR(AVERAGEIFS($L$9:$L$20,$B$9:$B$20,$A$24:$A$32),"") |
B33 | B33 | =SUM(B24:B32) |
C33 | C33 | =IFERROR(AVERAGE(C$24:C$32),"") |
D33 | D33 | =AVERAGE(D$24:D$32) |
Press CTRL+SHIFT+ENTER to enter array formulas. |