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 -

 

[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 -