Forum Discussion
Solved
How to group data from one column?
Dear Community, I am wondering about a formula I want to use. I got a database with a column for -Date -Department -Employees I am wondering if i can use a formula to group some departmen...
In such situation you can use multiple filter using the "or" sign ||, as follows:
Table = Filter(Sheet1, Sheet1[Department]="Sales"||Sheet1[Department]="Purchase")
Regards,
Hayman
Holy, thank you. It is working. Is there also another function which I can use the opposite way? So that I only have to type the things I want in it? I got a lot of departments to work with ^^
In such situation you can use multiple filter using the "or" sign ||, as follows:
Table = Filter(Sheet1, Sheet1[Department]="Sales"||Sheet1[Department]="Purchase")
Regards,
Hayman
Thank you for helping me out!