kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
I have a data set like this:
Range is B2:J16
With col E and H excluded.
And I want to count say all "A" which belong to an "x" in col A. Then all "A" for "y" through to "z" .
Then I repeat that for "B" to "I".
The output show have this format. By filling it with the
Range is B2:J16
With col E and H excluded.
Code:
|col A|Col B |Col C |Col D |Col E |Col F |Col G |Col H |Col I |Col J|
| x | B | B | G | | G | I | | A | A |
| y | A | A | E | | D | D | | F | F |
| z | I | I | F | | A | A | | C | C |
| x | H | C | C | | B | H | | D | D |
| y | B | D | H | | E | E | | F | A |
| z | I | B | G | | G | D | | C | C |
| x | A | A | E | | D | D | | F | F |
| y | I | I | G | | A | A | | C | C |
| z | H | C | C | | B | H | | D | D |
| x | I | D | H | | E | E | | B | A |
| y | B | B | G | | G | I | | C | C |
| z | A | A | E | | D | D | | F | F |
| x | I | I | G | | A | A | | C | C |
| y | H | C | C | | B | H | | D | D |
| z | B | D | H | | E | E | | F | A |
And I want to count say all "A" which belong to an "x" in col A. Then all "A" for "y" through to "z" .
Then I repeat that for "B" to "I".
The output show have this format. By filling it with the
Code:
|NAME |# of X |# of Y |# of Z |
| A | | | |
| B | | | |
| C | | | |
| D | | | |
| E | | | |
| F | | | |
| G | | | |
| H | | | |
| I | | | |