View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vic Vic is offline
external usenet poster
 
Posts: 117
Default Delete Rows based on condition

How do I perform elimination of row based on the following:
If L2 = M2 then leave this row alone and check the next row
Else
if B2=C2 and D2=E2 and F2=G2 and H2=I2 and J2=K2 and N2=O2 and P2=Q2 delete
this entire row (all 7 conditions must be met to eliminate this row)
If any of 7 conditions fail then I need to keep this row.
Thank you.