Formula to Verify values in multiple columns match, excluding Blanks

[clhuggins]

hey,

I'm getting lost in a sea of "If" statements. I'm not even sure that this is the best way to proceed.

I'm looking for a formula that can analyze whether or not all Values (Stocking types in this case) match in all columns (Branch). However, it is allowable that there are Blank values (or some other value like #N/A that denotes that no value exists), so i need a way to exclude those from the comparison.

See the chart below

[TABLE="width: 800"]
<tbody>[TR]
[TD]Number[/TD]
[TD]Branch 1[/TD]
[TD]Branch 2[/TD]
[TD]Branch 3[/TD]
[TD]Branch 4[/TD]
[TD]Branch 5[/TD]
[TD]Branch 6[/TD]
[TD]Check (formula)[/TD]
[/TR]
[TR]
[TD]ABC123
[/TD]
[TD]S[/TD]
[TD]P[/TD]
[TD][/TD]
[TD]P[/TD]
[TD]O[/TD]
[TD][/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD]ABC234[/TD]
[TD]P[/TD]
[TD]P[/TD]
[TD]P[/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]ABC456[/TD]
[TD]O[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Good[/TD]
[/TR]
</tbody>[/TABLE]

 

[clhuggins]

Here's what I've come up with so far, anyone have any better suggestions?

=AND(IF(C2="","TRUE",EXACT(C2,$B2)),IF(D2="","TRUE",EXACT(D2,$B2)),IF(E2="","TRUE",EXACT(E2,$F2))