Command Button for Identifying '1'

[LNT225]

Hi!

I have a large data set that is compiled within a table in excel (Table 1). Column B has names and all subsequent columns have headers concerning broken bones. If the person has a broken bone in column BS, there is a '1' in the row corresponding with their name. If they do not have a broken bone in Column BS, there is a '0' in the row corresponding with their name. There are 12 columns describing these fractures. I am trying to create a macro to easily locate all the '1's in the table out of 400 individuals. The issue being that when I try to filter the table by '1' in column BS it takes out all the '0's...but then when I want to filter by '1' in column BT, the data is limited to all those individuals who had a broken bone in BS and does not take into account individuals who did not have a broken bone in BS, but who had broken bones in BT. You can see where my issue is here because the data keeps becoming more and more limited as I continue to filter the columns. Is anyone able to help with this coding issue?

Coding for '0' seems to be much easier and I was able to make a simple code for that (below), but am having issues with coding for '1'.

Please Login or Register  to view this content.

[CK76]

You'd probably want to use advanced filter. Filtering in place.

See link for tutorial. Criteria range can be set up in another sheet.
https://www.thespreadsheetguru.com/b...pecific-values

[kasan]

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

Please Login or Register  to view this content.

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