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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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
118
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!