Using Data Filter

  • Thread starter Thread starter Robert B.
  • Start date Start date
R

Robert B.

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.
 
If you have In and Out in two different columns then what is is your
filter point? If you have both of them in one column say either a 1
or a zero, then your filter should give correct result for whatever
you choose.

AQIB RIZVI
 
Mr. Aquib Rizvi,

I have a Name Column, In / Out / In / Out Columns (Arrival, Dep, Arrival,
Dep). Say you arrive at work in the AM and then go out to lunch (Dep) and
come back (Arr) and then later on leave for the day (Dep) - 4 columns. I
have calculations created in other column that figures out who is either in
or out using a 1 or 0. The filter point is the calculation column. The
calculation column is giving me the correct 1 or 0. But when I ask Excel to
show me the report of who is in when say 1 person is in the list but nothing
is in the in/out/in/out columns it shows me this person.

Robert B.
 
Does your file look like this?

Name (columns ......) In or out?
Alf ( blah... ) in
Bert (blah... ) out
Cynthia (blah... ) in

If so, you can just use autofilter on that last column.

If it looks different you need to help us to visualise it.
 
Allllen,

Each Arrival and Departure Column is formated in Wingdings2 (shows check
mark when capital R is entered). The sample below shows all 4 people are not
onsite (onsite equals 1). I have a macro created that will run a report on
this worksheet to find all who are onsite (1). The example below shows all
are offsite but the report shows me all 4 are onsite (macro looks for 1 in
formula column using data filter) and then copies name column (say you have
50 people in list - A4 to A54)to another worksheet and pastes.

Name Arr Dep Arr
Dep (Formula)
Sally R R
0
Joe R
R 0
Robert R R
0
Jane R R
0

Robert B.
 
Back
Top