Does Excel include columns alone from a range?

1

Hello, I'm new here, but I have a problem with excel. I need to make a table that includes columns with a number from the name. In the base table the user will fill in the name of the person and his / her punctuation, and it is necessary that in another tab, with a table the name of the person will appear and the Excel will include the number that was filled in the base worksheet to each column. >

    A      B    C   D
1   JOÃO   2        1
2   JOSE        1   
3   MARIA  3    2   2
4   FRANCISCA       4   

Is this possible?

    
asked by anonymous 21.07.2017 / 15:12

1 answer

1

You can use the Excel PivotTable feature to do this. In it you can transform this data into an array where the name will be the column and the score the corresponding value, this feature calculates almost everything for you.

In this link explains the first few steps and I believe they are enough to give you the results you need.

    
21.07.2017 / 15:49