| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete rows with certain condition
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 - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on condition | Excel Discussion (Misc queries) | |||
| Delete Row with condition | Excel Discussion (Misc queries) | |||
| Delete rows with date more than 48 hours with a condition.. | Excel Worksheet Functions | |||
| Macro to delete rows based on a condition | Excel Worksheet Functions | |||
| how do I delete all rows that match a condition? | Excel Worksheet Functions | |||
Threaded Mode
