View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Delete an entire row if two cells......

Hi,

You could put an auto filter on columns B & C and filter both for "N". The
results would be only the rows containing N in both B & C. Then highlight
the row numbers and press Ctrl - (Ctrl + Minus).

--
Thanks,
Shane Devenshire
Microsoft Excel MVP

"Red2003XLT" wrote:

Hello All,

How do I delete (for an entire worksheet) rows that contain "N"?

The cells are "B and "C".

If "B" and "C" contain the letter "N" delete the entire row?
The letter "N" is the only thing in the cell.