hello experts,
i have a question, i never used advanced formulas in excel. Hope you guys will help me.
I want to make a matrix like table (below) from the raw data table
my answer table is this
<tbody>
</tbody>
and my raw data table is this given below. i want to count the column B and duplicates. and to make a table like matrix. Hope you understand my question.
my raw data table
<colgroup><col style="text-align: left; "><col style="text-align: left; "></colgroup><tbody>
</tbody>thanks in advance....
sajan raju
i have a question, i never used advanced formulas in excel. Hope you guys will help me.
I want to make a matrix like table (below) from the raw data table
my answer table is this
<colgroup><col><col span="5"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
and my raw data table is this given below. i want to count the column B and duplicates. and to make a table like matrix. Hope you understand my question.
my raw data table
ColA ColB
james | ABC |
johnson | XYZ |
david | JKD |
rahul | ABC |
andrews | ASD |
jacob | XYZ |
david | ASD |
rahul | ASD |
andrews | JKD |
davinci | JKD |
jacob | ABC |
james | ABD |
johnson | ASD |
<colgroup><col style="text-align: left; "><col style="text-align: left; "></colgroup><tbody>
</tbody>
sajan raju