| 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 - |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
delete rows with certain condition
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 :-) ---------------------------------------------------------------------------- "Grey" wrote in message ... 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 - --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003 |
| Reply |
| 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 | |||
Linear Mode
