excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
so i have this example below,
instead of just counting how many of values from f2:h2 appears in o2:q3 i want the results to be spilled, like instead of the current results in s2:u2 1-1-0 i want it to be 13-14 and 13-15, with no blanks
how?
so i have this example below,
instead of just counting how many of values from f2:h2 appears in o2:q3 i want the results to be spilled, like instead of the current results in s2:u2 1-1-0 i want it to be 13-14 and 13-15, with no blanks
how?
test | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
1 | set1 | set2 | |||||||||||||||||||||
2 | 13 | 14 | 15 | 16 | 13-14 | 13-15 | 13-16 | 13 | 17 | 18 | 15 | 13-17 | 13-18 | 13-15 | 1 | 1 | 0 | ||||||
3 | 14 | 13 | 16 | 20 | 13-14 | 14-16 | 14-20 | ||||||||||||||||
test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
S2:U2 | S2 | =COUNTIF(O2:Q3,F2:H2) |
Dynamic array formulas. |