Forum Discussion
Victor_Svensson
Dec 21, 2020Copper Contributor
Data formula
Hi! Hello! I want to create a complex formula and wonder how you solved it. In the excel sheet for investments, I have added a department and a person who is responsible for each purchase. Each y...
Riny_van_Eekelen
Dec 21, 2020Platinum Contributor
Victor_Svensson May I suggest that you collect all your data in one table and summarise it to your liking with the help of one or more pivot tables? I added an example to your file in the sheet called "PivotTable".
God Jul!
Victor_Svensson
Dec 23, 2020Copper Contributor
Thanks! I Will check this out!