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
|
|||
|
|||
If you have many rows, first sort the data by the numeric field. This will
gather all the zeros together and the rows can be deleted with one operation rather than hunting for them. -- Gary's Student "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) |