I have a worksheet with a list of names and in / out columns. I am trying to
sort the list of names by who is in or out (1 or 0). The problem I am having
is when say everybody in list is currently out (say offsite / 0) and I am
searching for who is in /1. The report generated (using data filter) shows
me everybody in list (when the report I want is who is in (should be a blank
report).

Can anybody help me with this. Any help will be greatly appreciated.

Robert B.