delete rows with certain condition

[Grey]

Dear All

For the below table, I want to know that how to to delete the rows if the "level" field is 2. does excel has any built-in function for doing this very easily. if so, how's it. If not, pls suggest the solution.

Million thanks





AgentNo Name Sub Agent SubAgent Name Level Purchase Amount
AG-A0 TESTER A0 AG-A1 TESTER A1 1 1,000.00
AG-A1 TESTER A1 AG-A11 TESTER A11 2 500.00
AG-A1 TESTER A1 AG-A12 TESTER A12 2 500.00
AG-A1 TESTER A1 AG-A13 TESTER A13 2 500.00
AG-A11 TESTER A11 AG-A21 TESTER A21 3 -
AG-A11 TESTER A11 AG-A22 TESTER A22 3 500.00
AG-A12 TESTER A12 AG-A23 TESTER A23 3 -
AG-A12 TESTER A12 AG-A24 TESTER A24 3 500.00
AG-A13 TESTER A13 AG-A25 TESTER A25 3 -
AG-A13 TESTER A13 AG-A26 TESTER A26 3 500.00
AG-A25 TESTER A25 AG-A36 TESTER A36 3 -

 

[Guest]

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

 

[Ken Wright]

Select the entire table of data and Do Data / Filter / Autofilter. Then click on the little dropdwon arrow that you will see in the cell with 'Level' in it. Select 2 and hit OK. You will noew see just the data you wish to remove. Select all the 2s, then do Edit / Go To / Special / Visible cells only and then do Edit / Delete / Entire Row.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
Seasons Greetings and Very Best wishes to all
----------------------------------------------------------------------------



Dear All

For the below table, I want to know that how to to delete the rows if the "level" field is 2. does excel has any built-in function for doing this very easily. if so, how's it. If not, pls suggest the solution.

Million thanks





AgentNo Name Sub Agent SubAgent Name Level Purchase Amount
AG-A0 TESTER A0 AG-A1 TESTER A1 1 1,000.00
AG-A1 TESTER A1 AG-A11 TESTER A11 2 500.00
AG-A1 TESTER A1 AG-A12 TESTER A12 2 500.00
AG-A1 TESTER A1 AG-A13 TESTER A13 2 500.00
AG-A11 TESTER A11 AG-A21 TESTER A21 3 -
AG-A11 TESTER A11 AG-A22 TESTER A22 3 500.00
AG-A12 TESTER A12 AG-A23 TESTER A23 3 -
AG-A12 TESTER A12 AG-A24 TESTER A24 3 500.00
AG-A13 TESTER A13 AG-A25 TESTER A25 3 -
AG-A13 TESTER A13 AG-A26 TESTER A26 3 500.00
AG-A25 TESTER A25 AG-A36 TESTER A36 3 -