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

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

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


"Gary''s Student" wrote in message
...
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

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" wrote in message
...
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

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" wrote in message
...

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