Jun 09 2022 08:35 AM - edited Jun 09 2022 08:35 AM
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? If possible, anyone could create it for me? Thanks in advance.
Excel sheets link: https://mega.nz/file/2p0BBCgC#x7g9Q1T4ELjgX4XcFb8gKAzmF0G2o9QIzFGjJMBMSL0
Jun 09 2022 08:57 AM
Solution
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
Jun 09 2022 08:57 AM
Solution
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