Forum Discussion
Solved
Need help with Excel
Hello, I'm new in using Excel and I would like to ask, if anyone has any ideas how to make from sheet 1 (Values, Date, Place), that it will calculate that table on the sheet 2 (RESULTS) like shown? I...
This isn't the format you specified, but it IS the result. And it's employing a popular feature of Excel known as the Pivot Table.
I've attached the spreadsheet. In addition, here's a good reference for learning about Pivot Tables. You'll also find many more on YouTube. https://exceljet.net/glossary/pivot-table
This isn't the format you specified, but it IS the result. And it's employing a popular feature of Excel known as the Pivot Table.
I've attached the spreadsheet. In addition, here's a good reference for learning about Pivot Tables. You'll also find many more on YouTube. https://exceljet.net/glossary/pivot-table