Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data Filter
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data Filter
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data Filter
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. "Aqib Rizvi" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data Filter
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 "Robert B." wrote: 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. "Aqib Rizvi" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Data Filter
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. "Allllen" wrote: 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 "Robert B." wrote: 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. "Aqib Rizvi" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell Data Filter Fails to Integrate New Data-rows | Excel Discussion (Misc queries) | |||
Filter data and fill only filtered data | Excel Discussion (Misc queries) | |||
Excel 2007 Data Filter - When using cut it clears all data | Excel Discussion (Misc queries) | |||
in data/filter/auto filter | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |