Hi excel master.
I need help to solve the case of searching and displaying data based on multi criteria using VBA, from the following example:
<tbody>
</tbody>
and here are the results I want to show in column F,G based on critera "S" in column B:
<tbody>
</tbody>
thank you in advance, for your help
I need help to solve the case of searching and displaying data based on multi criteria using VBA, from the following example:
A | B | |
1 | 100 | S |
2 | 100 | S |
3 | 100 | J |
4 | 103 | S |
5 | 103 | J |
6 | 103 | S |
7 | 104 | J |
8 | 104 | J |
9 | 104 | S |
10 | ... | ... |
<tbody>
</tbody>
and here are the results I want to show in column F,G based on critera "S" in column B:
F | G |
100 | 2 |
103 | 2 |
104 | 1 |
... | ... |
<tbody>
</tbody>
thank you in advance, for your help