Filters Q

[John]

I am trying to set up a very simple filter that wil extract all data from
Cols A:G that has a blank value within Col D. Col D = leaving date, thus my
new filtered list should just detail existing employees. I'm following the
very simple instructions but can't get it to work.

My criteria is in J1-J2. It has the same column heading as Col D and my
criteria is set as <0

Any help would be great

Thanks

[Gary''s Student]

Use Autofilter.

Data > Filter > Autofilter

On column D select NonBlank
--
Gary's Student


"John" wrote:

> I am trying to set up a very simple filter that wil extract all data from
> Cols A:G that has a blank value within Col D. Col D = leaving date, thus my
> new filtered list should just detail existing employees. I'm following the
> very simple instructions but can't get it to work.
>
> My criteria is in J1-J2. It has the same column heading as Col D and my
> criteria is set as <0
>
> Any help would be great
>
> Thanks
>
>
>

[John]

Thanks Gary, would I not have more flexibility in Advanced Filter?


"Gary''s Student" <[email protected]> wrote in message
news:[email protected]...
> Use Autofilter.
>
> Data > Filter > Autofilter
>
> On column D select NonBlank
> --
> Gary's Student
>
>
> "John" wrote:
>
>> I am trying to set up a very simple filter that wil extract all data from
>> Cols A:G that has a blank value within Col D. Col D = leaving date, thus
>> my
>> new filtered list should just detail existing employees. I'm following
>> the
>> very simple instructions but can't get it to work.
>>
>> My criteria is in J1-J2. It has the same column heading as Col D and my
>> criteria is set as <0
>>
>> Any help would be great
>>
>> Thanks
>>
>>
>>

[Gary''s Student]

You would have more flexibility using Advanced Filter. My suggestion was to
get you a practical solution as quickly as possible. I don't want to
discourage you from investigating Advanced Filters. Please see:

http://www.contextures.com/xladvfilter01.html#FilterUR

and have a pleasant day
--

Gary's Student


"John" wrote:

> Thanks Gary, would I not have more flexibility in Advanced Filter?
>
>
> "Gary''s Student" <[email protected]> wrote in message
> news:[email protected]...
> > Use Autofilter.
> >
> > Data > Filter > Autofilter
> >
> > On column D select NonBlank
> > --
> > Gary's Student
> >
> >
> > "John" wrote:
> >
> >> I am trying to set up a very simple filter that wil extract all data from
> >> Cols A:G that has a blank value within Col D. Col D = leaving date, thus
> >> my
> >> new filtered list should just detail existing employees. I'm following
> >> the
> >> very simple instructions but can't get it to work.
> >>
> >> My criteria is in J1-J2. It has the same column heading as Col D and my
> >> criteria is set as <0
> >>
> >> Any help would be great
> >>
> >> Thanks
> >>
> >>
> >>
>
>
>

[Debra Dalgleish]

There are instructions here for using an Advanced Filter to extract rows
with blank cells:

http://www.contextures.com/xladvfilter02.html#Blank

John wrote:
> Thanks Gary, would I not have more flexibility in Advanced Filter?
>
>
> "Gary''s Student" <[email protected]> wrote in message
> news:[email protected]...
>
>>Use Autofilter.
>>
>>Data > Filter > Autofilter
>>
>>On column D select NonBlank
>>--
>>Gary's Student
>>
>>
>>"John" wrote:
>>
>>
>>>I am trying to set up a very simple filter that wil extract all data from
>>>Cols A:G that has a blank value within Col D. Col D = leaving date, thus
>>>my
>>>new filtered list should just detail existing employees. I'm following
>>>the
>>>very simple instructions but can't get it to work.
>>>
>>>My criteria is in J1-J2. It has the same column heading as Col D and my
>>>criteria is set as <0
>>>
>>>Any help would be great
>>>
>>>Thanks
>>>
>>>
>>>
>>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html