Deleting Rows with Negative Numbers
[Closed]
Report
2t
-
RWomanizer
RWomanizer
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Related:
- How to delete rows with negative values in excel
- How to delete all negative numbers in excel - Best answers
- VB issue with delete rows with specific values ✓ - Forum - Excel
- Visual Basic - Deleting rows in spreadsheet - How-To - Excel
- Delete row in word table - How-To - Word
- Sed delete row - How-To - Sed
- Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
2 replies
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
please post a small extract of your data and explain again with respect to data
RWomanizer
- Posts
- 365
- Registration date
- Monday February 7, 2011
- Status
- Contributor
- Last seen
- September 30, 2013
Insert a column next to column H and use the formula is column I starting from second row as :
=OR(H2<0,H3<0)
now filter the data w.r.t column and for "TRUE"
delete all these row with value "TRUE".
Hope this well helps you.
=OR(H2<0,H3<0)
now filter the data w.r.t column and for "TRUE"
delete all these row with value "TRUE".
Hope this well helps you.
