| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete rows with negative values all at once i.e. 47,000.
Jean,
Yes. You can do it manually: Sort based on the column of values where the negative might be found, then select the cells with negative numbers and delete the rows. Or you could use a macro to do essentially the same thing. Just don't write a macro that steps through row by row.... HTH, Bernie MS Excel MVP "Jean" wrote in message ... I am using Excel and need to delete at least 47,000 rows with negative values in them all at once - Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ignore negative values when adding | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| Want to delete rows | Excel Discussion (Misc queries) | |||
| how do i prevent a #REF! error when i delete non adjacent rows? | Excel Worksheet Functions | |||
| delete repeating rows | Excel Worksheet Functions | |||
Hybrid Mode
