Prev: Filter (blanks) with two or more unique values not working
Next: Formula showing in cell
From: tsraj on 1 Apr 2010 14:41
I am trying to delete the entire row that meets cetain criteria.
The first criteria is a blank cell in column B
The second criteria is if the cell in column B contains "tot" or a prompt to
enter the criteria.

Any help is very much appreciated.

Thanks
From: מיכאל (מיקי) אבידן on 1 Apr 2010 14:58
You may use "Auto-Filter' or 'Advanced-Filter'.
After filtering you can copy/paste the remaining [visible] records to
another [lower] range/location and delete the original source records.
Micky


"tsraj" wrote:

> I am trying to delete the entire row that meets cetain criteria.
> The first criteria is a blank cell in column B
> The second criteria is if the cell in column B contains "tot" or a prompt to
> enter the criteria.
>
> Any help is very much appreciated.
>
> Thanks
 | 
Pages: 1
Prev: Filter (blanks) with two or more unique values not working
Next: Formula showing in cell