Some help needed with comparieson (Formula NOT VBA)

[zb134]

Consider a table like shown
[TABLE="width: 500"]
<tbody>[TR]
[TD]Shipment No.[/TD]
[TD]Company[/TD]
[TD]Match[/TD]
[/TR]
[TR]
[TD]s1[/TD]
[TD]a[/TD]
[TD]exception[/TD]
[/TR]
[TR]
[TD]s2[/TD]
[TD]b[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]s3[/TD]
[TD]a[/TD]
[TD]exception[/TD]
[/TR]
[TR]
[TD]s2[/TD]
[TD]b[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I want to do is in the 'Match' column, check if the same company has the same shipment number or not. The actual record has approx 300 values.

In the above table, since company 'a' has two shipment numbers s1 and s3, I want it to be shown as an exception in the match column while company 'b' has the same shipment number so it passes.

Thanks a lot!

 

[NeonRedSharpie]

Will there only be two instances of a company? Or can there be thirty instances? If there are thirty, do all thirty have to be S1 (or similar) to not throw an exception?

 

[zb134]

Will there only be two instances of a company? Or can there be thirty instances? If there are thirty, do all thirty have to be S1 (or similar) to not throw an exception?

There could be multiple instance of a company, what I have omitted is other columns like product code etc. But yes company A could be repeated 30 times and if even on of them is not the same shipment number, I want an exception for each corresponding col with the company. Hope that is clear.

 

[NeonRedSharpie]

=IF(COUNTIF($B$2:$B$5,$B2)=COUNTIFS($B$2:$B$5,$B2,$A$2:$A$5,$A2),"","exception")

Simple enough. Column A is your Shipment No. and column B is your Company.

 

[zb134]

=IF(COUNTIF($B$2:$B$5,$B2)=COUNTIFS($B$2:$B$5,$B2,$A$2:$A$5,$A2),"","exception")

Simple enough. Column A is your Shipment No. and column B is your Company.

Wow! Thanks a ton!