Deleting Rows with Negative Numbers

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,
I would like to delete spreasheet rows if column H contains a negative number and the line above it in excel. Please help!


2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
please post a small extract of your data and explain again with respect to data
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
119
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.