Hi All,
In excel i have the data like below(Column A and B)
<tbody>
</tbody>
I have the Unique name like A1, B1 and C1 in another cloumn J. I want to add all the A1, B1 and C1 and the output should look like below. there is no fixed order...A1 can be 3 times, 4 times, 5 times , B1 can be 1 time, 2 times and so on...
<tbody>
</tbody>
Is it possible to do this using formulas ? I do not want to use macro or VBA. Please help!!
Regards,
Niladri
****** id="cke_pastebin" style="position: absolute; top: 337px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
In excel i have the data like below(Column A and B)
A1 | BALOD |
A1 | DONDI |
A1 | DONDI Luhara |
B1 | BCSD |
B1 | VIVEK NAVEEN |
C1 | GFTKJ |
<tbody>
</tbody>
I have the Unique name like A1, B1 and C1 in another cloumn J. I want to add all the A1, B1 and C1 and the output should look like below. there is no fixed order...A1 can be 3 times, 4 times, 5 times , B1 can be 1 time, 2 times and so on...
A1 | BALOD;DONDI;DONDI Luhara |
B1 | BCSD;VIVEK NAVEEN |
C1 | GFTKJ |
<tbody>
</tbody>
Is it possible to do this using formulas ? I do not want to use macro or VBA. Please help!!
Regards,
Niladri
****** id="cke_pastebin" style="position: absolute; top: 337px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
GFTKJ |
<tbody>
</tbody>