delete row based on conditions

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

Is the assembly number and the part number different?

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)

"Jimmy Joseph" <jimmy.joseph@in.bosch.com> wrote in message
news:Xns97EC8657B2285jimmyjosephinboschco@client.loc.cc.bosch.com...
> 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