TrustMyUnit
New Member
- Joined
- Jun 24, 2019
- Messages
- 2
Hi all 
First time poster, great to be here! I've always been a big fan of Excel
I'm wondering if you could help me with a requirement I have please. We have two columns, one is our part number, and another is a supplier's part number:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Our Part Number[/TD]
[TD]Supplier's Part Number[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]FG-677[/TD]
[/TR]
[TR]
[TD]67890[/TD]
[TD]FG-688[/TD]
[/TR]
[TR]
[TD]24680[/TD]
[TD]FG-699[/TD]
[/TR]
[TR]
[TD]13579[/TD]
[TD]FG-699[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]FG-677[/TD]
[/TR]
</tbody>[/TABLE]
The situation is that duplicate Supplier Part Number's in column B is fine as long as column A is the same for each duplicate. In this example, I would want the row with Our Part Number as 13579 to be highlighted, as it's a duplicated Supplier Part Number, but the Our Part Number on those rows are different.
Is this even possible please?
Thank you so much in advance!
Matt

First time poster, great to be here! I've always been a big fan of Excel

I'm wondering if you could help me with a requirement I have please. We have two columns, one is our part number, and another is a supplier's part number:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Our Part Number[/TD]
[TD]Supplier's Part Number[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]FG-677[/TD]
[/TR]
[TR]
[TD]67890[/TD]
[TD]FG-688[/TD]
[/TR]
[TR]
[TD]24680[/TD]
[TD]FG-699[/TD]
[/TR]
[TR]
[TD]13579[/TD]
[TD]FG-699[/TD]
[/TR]
[TR]
[TD]12345[/TD]
[TD]FG-677[/TD]
[/TR]
</tbody>[/TABLE]
The situation is that duplicate Supplier Part Number's in column B is fine as long as column A is the same for each duplicate. In this example, I would want the row with Our Part Number as 13579 to be highlighted, as it's a duplicated Supplier Part Number, but the Our Part Number on those rows are different.
Is this even possible please?

Thank you so much in advance!
Matt