Hi Experts,
I have the below given two column.And I would like to have result as shown under the title RESULT.Could you please provide me some Macro or any formula to achieve this.
<colgroup><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
RESULT :
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Regards,
Kavvya
I have the below given two column.And I would like to have result as shown under the title RESULT.Could you please provide me some Macro or any formula to achieve this.
Name | Company |
CAR1 | Transport-01 |
CAR1 | Transport-01 |
ZEEP1 | Transport-01 |
ZEEP1 | Transport-01 |
CAR2 | Transport-01 |
CAR2 | Transport-01 |
B1 | Transport-01 |
B1 | Transport-01 |
B2 | Transport-01 |
B2 | Transport-01 |
CAR3 | Transport-02 |
CAR3 | Transport-02 |
ZEEP2 | Transport-02 |
ZEEP2 | Transport-02 |
CAR4 | Transport-02 |
CAR4 | Transport-02 |
CAR5 | Transport-02 |
CAR5 | Transport-02 |
<colgroup><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
RESULT :
Company | Name | Total |
Transport-01 | CAR | 2 |
Transport-01 | ZEEP | 1 |
Transport-01 | B | 2 |
Transport-02 | CAR | 3 |
Transport-02 | ZEEP | 1 |
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Regards,
Kavvya