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:

Part name	car1	car2	car3	solution
window	5.00	0	0
muffler	120	120	45	car 1, car2
door handle	16	16	16	car1, car2, car3
hood	45	96	45	car 1, car3

<TBODY>
</TBODY>

 

[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!!!