Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
how to delete rows
I have a work sheet that has many rows like this and 3 coloums
1 chair custom 24 2 table custom 0 3 spoon custom 3563 4 hat custom 0 now I would like to make another colom and only extract those that their sum is greather than zero. in other words I would like to delete rows 2 and 4 how can i do that using if-function or any other function tnx khers |
#2
|
|||
|
|||
You can use Auto Filter ,First select all then From menu choose Data -
Filter - Auto Filter , Now you can select 0 Value from drop down of col.no.3 & then delete row . The above process delete all row with 0 value in col.3 Sanjeev "Khers" wrote: I have a work sheet that has many rows like this and 3 coloums 1 chair custom 24 2 table custom 0 3 spoon custom 3563 4 hat custom 0 now I would like to make another colom and only extract those that their sum is greather than zero. in other words I would like to delete rows 2 and 4 how can i do that using if-function or any other function tnx khers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can we delete rows permanently from excel sheet | Excel Discussion (Misc queries) | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
How to delete blank rows | Excel Discussion (Misc queries) |