Cell Formulas | ||
---|---|---|
Range | Formula | |
B2:B10 | B2 | =IFERROR(AGGREGATE(15,6,(ROW(INDIRECT("1:10")))/(COUNTIFS($A$2:$A$751,(ROW(INDIRECT("1:10"))))=0),ROWS($A$2:B2)),"") |
Hi Stephen
21 02 10.xlsm | ||||
---|---|---|---|---|
A | B | |||
1 | 1 | 7 | ||
2 | 2 | 9 | ||
3 | 3 | |||
4 | 4 | |||
5 | 5 | |||
6 | 6 | |||
7 | 8 | |||
8 | 10 | |||
9 | ||||
10 | ||||
Missing |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1:B2 | B1 | =FILTER(SEQUENCE(10),ISNA(MATCH(SEQUENCE(10),A1:A10,0)),"") |
Dynamic array formulas. |