excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
i want to count how many numbers is repeating from row2 to row 3,
and again from row 2 to row 4 - but this time if the repeated one is in here (row2:row4) and is identical to the one found in row2:row3, then ruling it out/skip it, and count only if there's new one
is it possible?
the main example is in g2:i2
i want to count how many numbers is repeating from row2 to row 3,
and again from row 2 to row 4 - but this time if the repeated one is in here (row2:row4) and is identical to the one found in row2:row3, then ruling it out/skip it, and count only if there's new one
is it possible?
the main example is in g2:i2
test.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | 1 | 2 | 3 | 4 | 5 | 6 | row 2+3 | row 2+4 | row 2+5 | ||
2 | 1 | 12 | 20 | 22 | 27 | 32 | 1 | 2 | 3 | ||
3 | 2 | 14 | 16 | 31 | 32 | 33 | 2 | 1 | 1 | ||
4 | 2 | 6 | 17 | 20 | 32 | 36 | 1 | 1 | 2 | ||
5 | 4 | 12 | 20 | 22 | 33 | 37 | 2 | 1 | 2 | ||
6 | 3 | 12 | 18 | 32 | 35 | 37 | |||||
7 | 1 | 3 | 19 | 32 | 36 | 37 | |||||
8 | 4 | 5 | 18 | 35 | 36 | 37 | |||||
test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G2:G5 | G2 | =SUM(--(COUNTIF(A3:F3,A2:F2)>0)) |
H2:H5 | H2 | =SUM(--(COUNTIF(A4:F4,A2:F2)>0)) |
I2:I5 | I2 | =SUM(--(COUNTIF(A5:F5,A2:F2)>0)) |