Deleting Rows with Negative Numbers [Closed]

Question

Deleting Rows with Negative Numbers [Closed]

Report

2t - Dec 14, 2011 at 08:47 PM
RWomanizer

Posts: 365
Registration date: Monday February 7, 2011
Status: Contributor
Last seen: September 30, 2013

- Dec 15, 2011 at 12:31 AM

Hello,
I would like to delete spreasheet rows if column H contains a negative number and the line above it in excel. Please help!

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
Excel - A macro for deleting row on condition - How-To - Excel
Visual Basic - Deleting rows in spreadsheet - How-To - Excel
Delete row in word table - How-To - Word
Sed delete row - How-To - Sed

2 replies

Ask a question

venkat1926 · Answer 1 · 2011-12-14T22:50:54-0500

Answer 1 / 2

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
Dec 14, 2011 at 10:50 PM

please post a small extract of your data and explain again with respect to data

RWomanizer · Answer 2 · 2011-12-15T00:31:20-0500

Answer 2 / 2

RWomanizer

Posts: 365
Registration date: Monday February 7, 2011
Status: Contributor
Last seen: September 30, 2013

118
Dec 15, 2011 at 12:31 AM

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.

Deleting Rows with Negative Numbers [Closed]

2 replies

Your reply

Subscribe To Our Newsletter!