Extract name

[ehsas63]

Hi

I need help on how to extract unique name from the excel cell and then sum up the total score for each name.

I have excel sheet where the name for all participates has entered in one cell as example below


Name Score
ABC;#DEF;#HIJ;# 5
ABC;#XYZ;#HIJ;# 2
MNO;#DEF;#HIJ;# 3
ABC;#DEF;#QRS;# 5

I need help on formula to first extra the unique name from each cell in seperate column such as below

ABC
DEF
HIJ
XYZ

Then I need another formula to sum up the total score for each individua as example below

Name Score
ABC 12
DEF 13
HIJ 10

Thanks

 

[DanteAmor]

Finally select the cells with the result, from F1 to G16 and create a dynamic table to see the scores of each name.

Folow the next steps
1. Select data from cell F1 to G16
2. Menu Insert, Dynamic Table, Dynamic Table
3. New sheet
4. Enter
5. In Fields of Dynamic Table, click Name and Value
6. Ready!

See image
https://www.dropbox.com/s/ljeafpg7iz...%20td.jpg?dl=0

(You can watch any video to create dynamic tables on youtube)

 

[ehsas63]

Thanks Dante Amor. Appreciated.

Finally select the cells with the result, from F1 to G16 and create a dynamic table to see the scores of each name.

Folow the next steps
1. Select data from cell F1 to G16
2. Menu Insert, Dynamic Table, Dynamic Table
3. New sheet
4. Enter
5. In Fields of Dynamic Table, click Name and Value
6. Ready!

See image
https://www.dropbox.com/s/ljeafpg7iz...%20td.jpg?dl=0

(You can watch any video to create dynamic tables on youtube)

 

[DanteAmor]

I'm glad tu help you!