| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Rows based on condition
How do I perform elimination of row based on the following:
If L2 = M2 then leave this row alone and check the next row Else if B2=C2 and D2=E2 and F2=G2 and H2=I2 and J2=K2 and N2=O2 and P2=Q2 delete this entire row (all 7 conditions must be met to eliminate this row) If any of 7 conditions fail then I need to keep this row. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to delete an excel line based on a condition | Excel Worksheet Functions | |||
| Delete row 1 based on condition in cell on row 2 | Excel Worksheet Functions | |||
| Macro to delete rows based on a condition | Excel Worksheet Functions | |||
| How to delete a data row based on a condition | New Users to Excel | |||
| Is there a way to delete a cell value based on a condition? | Excel Discussion (Misc queries) | |||
Threaded Mode
