Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
delete row based on value of ...
using a macro to delete a row.
how can i delete a row if the value of a cell is 0 or less... Column A has an item number Column B has quantities, from a negative number, 0, and positive numbers if a cell in Column B is 0 or lower, the row will be deleted. i can delete rows using F5, Special, Blanks, delete row..., so i am hoping for somthing like that where i can record a macro to work with. thank you, jat |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
delete row based on value of ...
Hi,
Type the following formula =1/(A10) in a blank column on the first row of your data. Copy it down. All rows with DIV/0 will be marked for deletion. Highlight all the cell and press F5, Special, choose Formulas and uncheck all except Errors. Click OK. Press Ctrl - (Ctrl minus) and choose Entire row, OK. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "jatman" wrote: using a macro to delete a row. how can i delete a row if the value of a cell is 0 or less... Column A has an item number Column B has quantities, from a negative number, 0, and positive numbers if a cell in Column B is 0 or lower, the row will be deleted. i can delete rows using F5, Special, Blanks, delete row..., so i am hoping for somthing like that where i can record a macro to work with. thank you, jat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows Based on Words | Excel Discussion (Misc queries) | |||
Delete row based on cell value | Excel Discussion (Misc queries) | |||
delete row on based on cell value | Excel Discussion (Misc queries) | |||
How to delete a data row based on a condition | New Users to Excel | |||
delete based on | Excel Discussion (Misc queries) |