Steve17701
New Member
- Joined
- Mar 17, 2023
- Messages
- 12
- Office Version
- 2019
- Platform
- Windows
test.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
F | G | H | I | J | K | |||
4 | I am using Excel 2019 on Windows. I have a table of numbers I want to count the number of matches with the numbers above, In cell D3 I used a Count(Match()) array formula and it works. However, when I tab to add a new row the the formula in D3 changes. The first parameter to the Match function becomes a two dementional array, as does the the formula in D6. Why? What am I doing wrong? Is there a better way? | |||||||
5 | ||||||||
6 | ||||||||
7 | ||||||||
8 | ||||||||
9 | ||||||||
10 | ||||||||
11 | ||||||||
12 | ||||||||
13 | ||||||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | ||||||||
18 | ||||||||
19 | ||||||||
20 | ||||||||
Sheet1 |