Matching up Duplicate Cross Reference Numbers

[NitroRoo]

I have a sheet with ~14k cross reference numbers. Column A is the Vendor number, and Column B is the possible OEM number for that part. I need to identify when the parts in Column B occur next to more than 1 number in column A. In the example below I have highlighted parts that have duplicate values in Column B. You can see that the first two highlighted duplicates do not have their duplicate values next to vendornum 1011015 (they occur further down the list next to 1017003). However the two middle duplicate values are both next to 1012006, so those are ok (for now, next step will be to pull those as it's a separate issue).

The goal is to identify oemnum such as 301322 and 3322, and ultimately pull those entire rows into another sheet and remove them from the original.

[TABLE="align: left"]
<tbody>[TR]
[TD="******* 19, align: right"]1[/TD]
[TD="******* 81, align: left"]vendornum[/TD]
[TD="******* 123, align: left"]oemnum[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]2[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, align: left"]ZGG11028[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]3[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, align: left"]C7AZ-19805-B[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]4[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, align: left"]35501[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]5[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, bgcolor: #FFC7CE, align: left"]301322[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]6[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, bgcolor: #FFC7CE, align: left"]3322[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]7[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, align: left"]01-2680[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]8[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, align: left"]BM-0393[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]9[/TD]
[TD="******* 81, align: left"]1011015[/TD]
[TD="******* 123, align: left"]1011015[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]10[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, bgcolor: #FFC7CE, align: left"]BOA-80-415-00-789[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]11[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, align: left"]2898-091-028[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]12[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, align: left"]301317[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]13[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, bgcolor: #FFC7CE, align: left"]BOA-80-415-00-789[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]14[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, align: left"]ZGG701024[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]15[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, align: left"]3944[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]16[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, align: left"]01-0609[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]17[/TD]
[TD="******* 81, align: left"]1012006[/TD]
[TD="******* 123, align: left"]274379[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]18[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, align: left"]35546[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]19[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, bgcolor: #FFC7CE, align: left"]301322[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]20[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, align: left"]BSM-301082[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]21[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, align: left"]1691705C91[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]22[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, bgcolor: #FFC7CE, align: left"]3322[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]23[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, align: left"]01-2608,-01-2624[/TD]
[/TR]
[TR]
[TD="******* 19, align: right"]24[/TD]
[TD="******* 81, align: left"]1017003[/TD]
[TD="******* 123, align: left"]274318[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

 

[MickG]

Can you send an example of the data it failed on.
Possible using "Box.com" (free filesharing)