Delete Rows if certain conditions exist

[TXG8T3R]

I have a spreadsheet that I am trying to clean up.

If an Order number has as it's Status both a PUR and a RCV, I want to delete both rows,
leaving only Order Numbers with the Status of PUR.

How would I go about doing that?

Example below:

Order Number Status 000000177 PUR 000000230 RCV 000000230 PUR 000000240 RCV 000000240 PUR 000000252 PUR 000000300 PUR <tbody> </tbody>



<tbody>
</tbody>

 

[sheetspread]

(Forget what I wrote before). You can write a countif formula to return an error or number that F5(Goto)-special can pick up, then delete the rows:

Excel 2010
	A	B	C
1	Order Number	Status
2	177	PUR	1
3	230	RCV	#DIV/0!
4	230	PUR	#DIV/0!
5	240	RCV	#DIV/0!
6	240	PUR	#DIV/0!
7	252	PUR	1
8	300	PUR	1
Sheet3

Cell Formulas
Range	Formula
C2	=IF(COUNTIF($A$2:$A$8,A2)=2,1/0,1)

Assuming the order number never appears more than twice, otherwise an extra condition can be added.