How to group data and list another table in excel

2

Hello.

I have a shopping chart with several records and wanted to create a list / table next to it that contained the place of purchase and the front the total amount spent in that store. here is an example of what I want.

<table><tr><th>NOME</th><th>VALOR</th></tr><tr><td>RP</td><td>192</td></tr><tr><td>RM</td><td>18</td></tr><tr><td>RP</td><td>92</td></tr></table>

Above and the table with the various data below comes the table I want

<table>
  <tr>
    <th>NOME</th>
    <th>VALOR</th>
  </tr>
  <tr>
    <td>RM</td>
    <td>18</td>
  </tr>
  <tr>
    <td>RP</td>
    <td>284</td>
  </tr>
</table>

bold text

How do I get this in excel if possible only with formulas without macros.

Thanks in advance to everyone

    
asked by anonymous 16.07.2018 / 13:02

1 answer

0

Dynamic Table

You can do this with a PivotTable.

In Inserir > Tabela Dinâmica , as shown below:

Result

<table><tbody><tr><th>Rótulos de Linha</th><th>Soma de VALOR</th></tr><tr><td>RM</td><td>18</td></tr><tr><td>RP</td><td>284</td></tr><tr><td>Total Geral</td><td>302</td></tr></tbody></table>
    
16.07.2018 / 13:41