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