The formulae in F6 produces the solution needed however it also contains blank spaces and zeroes. I've had this happen before with array formulae, how can we clean this formula up?
Football stats functions.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Group 1 | Group 2 | |||||||
2 | Jack | Ken | Peter | Vic | #VALUE! | ||||
3 | Tom | Sally | Tom | Fred | |||||
4 | Peter | Vic | Jane | Milton | |||||
5 | Jane | Sally | |||||||
6 | |||||||||
7 | Fred | ||||||||
8 | Milton | ||||||||
9 | 0 | ||||||||
Sheet17 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2 | F2 | =FILTER($A$2:$B$5,NOT(COUNTIF($D$2:$E$5,$A$2:$B$5))) |
F6:G9 | F6 | =IF(COUNTIF(A2:B5,D2:E5)=0,D2:E5,"") |
Dynamic array formulas. |