Hi,
I would suggest to make a trick with our data before filters are applied.
You could make additional column (probably it can be the last column, after all your data).
Then write a formula in cell
Formula:
=COUNTIF(C2:F2;1)
where C2:F2 is range with 1 or 0 and 1 - is criteria for counting.
Copy this formula down and you will get one, common criteria to filter out all data with 1 or 0.
As little bonus - you will able to filter out persons, who have more than one broken bone, because formula will count how much '1' there are in one row.
As far you didn't provide any sample data - check attached file for better understanding of what I'm trying to tell you![]()
Bookmarks