Forum Discussion
0xygen27
Advocate II
Advocate IIHow 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
0xygen27Advocate II
Advocate IIHoly, 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 ^^
haymanezzeldin
Helper I
Helper IIn such situation you can use multiple filter using the "or" sign ||, as follows:
Table = Filter(Sheet1, Sheet1[Department]="Sales"||Sheet1[Department]="Purchase")
Regards,
Hayman
- 0xygen27
Thank you for helping me out!