| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows with specific values
Good day all
Below i have a table that i would like to manipulate by deleting all rows with 0.00h in its Remaining Duration column, to see it properly i would suggest to cut and past it. I think i have done this action before but need some help do do it this time. Activity ID M/E Phase Activity Name Start Finish Visit Frequency Remaining Duration 05-Mar-06 07-Mar-06 8.00h Acme Station Elect 4.1 (a-i) 05-Mar-06 05-Mar-06 Q 2.00h Acme Station Elect 4.1 (j-s) 05-Mar-06 06-Mar-06 HY 2.00h Acme Station Elect 4.2.1 (a-k) 05-Mar-06 05-Mar-06 HY 0.50h Acme Station Elect 4.2.2 (a-k) 05-Mar-06 05-Mar-06 HY 0.50h Acme Station Elect 4.2.3 (a-j) 05-Mar-06 05-Mar-06 Q 0.50h Acme Station Elect 4.2.4.1 (a-x) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.2.4.2 (y-xx) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.2.4.3 (a-w) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.2.4.4 (x-gg) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.3 (f-r) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.3.1 (a-h) 06-Mar-06 06-Mar-06 HY 0.50h Acme Station Elect 4.3.2 (a-g) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.4.1.1 (a-f) 06-Mar-06 06-Mar-06 HY 0.08h Acme Station Elect 4.4.1.2 a 06-Mar-06 06-Mar-06 HY 0.08h Acme Station Elect 4.4.1.3 a 06-Mar-06 06-Mar-06 HY 0.08h Thanks Orly |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting rows with specific values
Thanks all but i have just remembered that all i had to do is to create a
filter and then delete rows. I would still welcome any better suggestion. Thanks in advance "whatzzup" wrote: Good day all Below i have a table that i would like to manipulate by deleting all rows with 0.00h in its Remaining Duration column, to see it properly i would suggest to cut and past it. I think i have done this action before but need some help do do it this time. Activity ID M/E Phase Activity Name Start Finish Visit Frequency Remaining Duration 05-Mar-06 07-Mar-06 8.00h Acme Station Elect 4.1 (a-i) 05-Mar-06 05-Mar-06 Q 2.00h Acme Station Elect 4.1 (j-s) 05-Mar-06 06-Mar-06 HY 2.00h Acme Station Elect 4.2.1 (a-k) 05-Mar-06 05-Mar-06 HY 0.50h Acme Station Elect 4.2.2 (a-k) 05-Mar-06 05-Mar-06 HY 0.50h Acme Station Elect 4.2.3 (a-j) 05-Mar-06 05-Mar-06 Q 0.50h Acme Station Elect 4.2.4.1 (a-x) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.2.4.2 (y-xx) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.2.4.3 (a-w) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.2.4.4 (x-gg) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.3 (f-r) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.3.1 (a-h) 06-Mar-06 06-Mar-06 HY 0.50h Acme Station Elect 4.3.2 (a-g) 06-Mar-06 06-Mar-06 HY 0.00h Acme Station Elect 4.4.1.1 (a-f) 06-Mar-06 06-Mar-06 HY 0.08h Acme Station Elect 4.4.1.2 a 06-Mar-06 06-Mar-06 HY 0.08h Acme Station Elect 4.4.1.3 a 06-Mar-06 06-Mar-06 HY 0.08h Thanks Orly |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
| Deleting Specific Rows | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Insert rows | Excel Worksheet Functions | |||
Linear Mode
