snap3340.png
I have data as in the image. I would like to use filter to show homes that have a fish or any combination animals. I can manage data in the other format if it can working with combination filter.
If I sort data eg. Fish to column B, Bird can be in column B or C too.
Total 25 types of animal.
One home can be 5 types of animal.
Bookmarks