Nov 04 2022 11:23 AM
I am working on a sheet with a list of people from different departments and would like to sort the list by departments into different sheets in the same workbook automatically. I have been trying to use the filter formula but I can't see to get it right.
What would be the best way to do this?
Nov 04 2022 11:41 AM
SolutionYou can apply a Pivot Table like in the screenshot. If you then double-click on cell E2 a new sheet is created which shows a table of all employees in the Engineering department. This can be done correspondingly for the other departments if you double-click in cells E3, E4 and E5.
Nov 04 2022 01:27 PM
Any chance you could show a screenshot of the side of the screen with the Pivot Table Fields set up? I am having trouble making it look the same and I am wondering how you arranged it?
Nov 04 2022 02:46 PM
Of course. In the screenshot you can see the set up and "Anzahl" is the "Count" in english.
Nov 04 2022 02:51 PM
Nov 04 2022 11:41 AM
SolutionYou can apply a Pivot Table like in the screenshot. If you then double-click on cell E2 a new sheet is created which shows a table of all employees in the Engineering department. This can be done correspondingly for the other departments if you double-click in cells E3, E4 and E5.