Matching common data from 3 columns?

[wisemank]

Good Morning,

I am looking to identify the data I have from three (3) columns and verify if they are common to each other. Columns F,G & H hold the cost values for parts on 3 different cars. I want to know if the cost matches between the three cars to see if they are shared. below is an example:

[TABLE="width: 500"]
<TBODY>[TR]
[TD]Part name[/TD]
[TD]car1[/TD]
[TD]car2[/TD]
[TD]car3[/TD]
[TD]solution[/TD]
[/TR]
[TR]
[TD]window[/TD]
[TD]5.00[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]muffler[/TD]
[TD]120[/TD]
[TD]120[/TD]
[TD]45[/TD]
[TD]car 1, car2 [/TD]
[/TR]
[TR]
[TD]door handle[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]car1, car2, car3[/TD]
[/TR]
[TR]
[TD]hood[/TD]
[TD]45[/TD]
[TD]96[/TD]
[TD]45[/TD]
[TD]car 1, car3 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[mikerickson]

Perhaps
=REPT("car1 ", 1 < COUNTIF(A1:C1,A1))&REPT("car2 ", 1 < COUNTIF(A1:C1,B1))&REPT("car3 ", 1 < COUNTIF(A1:C1,C1))

 

[Andrew Poulsom]

An alternative:

=IF(COUNTIF(B2:D2,B2)>1,B$1&", ","")&IF(COUNTIF(B2:D2,C2)>1,C$1&REPT(", ",C2=D2),"")&IF(COUNTIF(B2:D2,D2)>1,D$1,"")

 

[wisemank]

Thanks to both of you, Both scenarios are perfect. You guys are great!!!