Hi
I have a table with the following data.
<tbody>
</tbody>
I would like to know what is the unique number of locations for each band. ie
<tbody>
</tbody>
Please help.
I have a table with the following data.
Band | Salesmen | Location1 | Location2 | Location3 |
X | A | Delhi | Mumbai | Chennai |
Y | B | Kolkata | Chennai | |
Z | C | Chennai | Mumbai | |
X | D | Mumbai | ||
Y | E | Mumbai | Chennai |
<tbody>
</tbody>
I would like to know what is the unique number of locations for each band. ie
X | 3 |
Y | 3 |
Z | 2 |
<tbody>
</tbody>
Please help.