Hi All,
Could someone please help me with the query below
I have 3 sheets Labels, Labels and Categories and Results. I have to check the all the values in Labels sheet against Labels and Categories sheet and report the total numbers in Result sheet. Please see example below.
Thanks in advance!
Labels sheet
<tbody>
</tbody>
Labels and Categories sheet
<tbody>
</tbody>
Results Sheet
<tbody>
</tbody>
Thanks
Could someone please help me with the query below
I have 3 sheets Labels, Labels and Categories and Results. I have to check the all the values in Labels sheet against Labels and Categories sheet and report the total numbers in Result sheet. Please see example below.
Thanks in advance!
Labels sheet
Label1 | Label2 | Label3 |
12345 | 12345 | 12345 |
1234 | 12 | 1234 |
12345 | 12345 |
<tbody>
</tbody>
Labels and Categories sheet
Label | Category |
12345 | A |
1234 | B |
12 | C |
<tbody>
</tbody>
Results Sheet
Categories | Total Labels |
A | 5 |
B | 2 |
C | 1 |
<tbody>
</tbody>
Thanks