"robert mills" wrote:
how do i find nonblank filters in excel when working with spreadsheets

Just sparing a thought here, as you haven't received any response yet (not
sure why, though <g). ok, I don't have/know the latest xl2007, but would it
be any different from say, xl2003, where the option to choose: (NonBlanks) is
available in the autofilter dropdown (via Data Filter Autofilter)?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---