Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet with calculations that may result in a zero balance.
How do I automatically delete all rows with a zero balance? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Fri, 25 Aug 2006 06:35:01 -0700, suec4
wrote: I have a spreadsheet with calculations that may result in a zero balance. How do I automatically delete all rows with a zero balance? One way would be to filter the list to display the zero values. Then delete those rows and unfilter the list. If you want it to be automatic, then a simple macro to perform those steps would do the trick. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete blank rows | Excel Discussion (Misc queries) | |||
Excel - How do I delete filtered out rows? | Excel Discussion (Misc queries) | |||
delete rows | Excel Discussion (Misc queries) | |||
Delete Rows where cells does not meet criteria | Excel Worksheet Functions | |||
delete repeating rows | Excel Worksheet Functions |