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