@sheet Sheet1
| A | B | C | D | E | F | G | H |
| --- | --- | --- | --- | --- | --- | --- | --- |
| apple | 3 |  |  |  | '007 |  |  |
| pear | 1 | =COUNTA(A2:B3) | =COUNTIFS(A2:A3,"apple") | =XLOOKUP("pear",A2:A3,B2:B3) | 007 | =FILTER(A2:B3,A2:A3="apple") |  |
|  | 5 |  |  |  |  |  | =UNIQUE(A2:A3) |
|  | 7 |  |  |  |  |  |  |
@endsheet