Selecting All Rows with Certain Data
 

See he http://www.contextures.com/xladvfilter02.html and scroll to the
bottom.

Dave
--
Brevity is the soul of wit.


"DCrabill" wrote:

Hello,

I am attempting to select all of the rows within a spreadsheet in which a
particular cell within that row is blank (contains no information). I want
to remove these rows from my spreadsheet, but it is over 2000 rows long and I
do not want to select them individually. Please advise. Thanks very much!