delete row based on conditions

J

Jimmy Joseph

Hello,

I have a list as below


Assembly Part number Pos

A xxxxxx 2500
A yyyyyy 2591
B aaaaaa 2500
B bbbbbb 2591
D cccccc 2591
E dddddd 2500

I wanted to delete the entire row containing pos.2500 if for the same
Assembly number Pos.2500 and Pos2591 exists.

How to do it?

Regards,

Jimmy Joseph
 
B

Bob Phillips

Add a helper column with a formula of

=COUNTIF(A2:A$2000)>1

and then filter that column by TRUE, delete visible rows, then delete the
helper column.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top