Forum Discussion
Filtering rows with multiple conditions
Hello, I have a problem with filtering certain rows. I would like to filter out from all of my data rows, which firstly in column "Category" are "Candies" and column "Accounts" are anything els...
Hi,
Share some data to work with and also show your expected result.
I created an example to excel:
And result should be like this:
All the other candies with accounts, which are not 123 and 345, are gone.
Does this help?
Hi,
Why are 879 and 478 appearing there? I just do not understand your filtering conditions.
Hi,
It is hard to make an example table to you, I cannot present the real data. But these are just for example that you could understand that I have not got only candies with accounts, but other things as pies with the same accounts as well. So actually I need that all the other data would remain the same and Candies would appear only with accounts 123 and 345. Does it make more sense? :)
Is there anyone, who could help?