M Mortir Feb 8, 2009 #1 id like to filter out the rows that have blanks in a certain column. what condition do i give for criteria range?
id like to filter out the rows that have blanks in a certain column. what condition do i give for criteria range?
M Mortir Feb 8, 2009 #3 Hi Use an AutoFilter, and select NonBlank as criteria. Hopes this helps. Click to expand... hi. tnx, but id like to do it with advanced filter> plus id like to get the result of advanced filter so that Only the rows that have blanks in a certain column show up
Hi Use an AutoFilter, and select NonBlank as criteria. Hopes this helps. Click to expand... hi. tnx, but id like to do it with advanced filter> plus id like to get the result of advanced filter so that Only the rows that have blanks in a certain column show up
