| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
deleting certain rows
I have an 800 page spreadsheet where I need to delete all rows that have zero
in columns J through M. Can anyone steer me in the right direction. -- Marie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
deleting certain rows
I'd probably add a helper column
In that column I'd put =COUNTIF(J2:M2,0) 'in column 2 for example Copy down to the end and use autofilter to find the ones that have a value of 4 and delete. -- HTH, Barb Reinhardt "Marie" wrote: I have an 800 page spreadsheet where I need to delete all rows that have zero in columns J through M. Can anyone steer me in the right direction. -- Marie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting rows | Excel Discussion (Misc queries) | |||
| deleting rows | Excel Discussion (Misc queries) | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| rows that need deleting | Excel Worksheet Functions | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Linear Mode
