How to group data and list in another excel table

Asked

Viewed 116 times

2

Hello.

I have a shopping list with several records and wanted to create a list/table next to it that contained the place of purchase and ahead of the total amount spent in this store. follows below 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 following data 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.

Since thanks to everyone

excel

1 answer

0

Table Dynamics

This can be done with a dynamic table.

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

Inserir Tabela Dinâmica

Upshot

Resultado

<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>

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.