View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ben.c ben.c is offline
external usenet poster
 
Posts: 32
Default delete rows with certain condition

Hi Grey
You can do it easily on excel with the autofilter. clikc on the first cell of the level column and the n go on : data, filter, autofilter. You will have on cell 1 of each column near the level column a filter witch allows you to choose witch condition do you want. So you take the one of the level column and click on 2. Then just select all the rows and delete them. Finally put all in the filter and you will have all the others rows
Best regard
Benjami
PS: Don't forget to stop the autofilter if you want to do insert-delete column