Excell 2003
Hi, I am trying to check to see if the same data exists within three columns on the same row
I need a if statment or something that checks the three columns across the row, and depending on the result gives an answer, so if Column1 Titled A", Column2 Titled "B" & Column3 Titled "C", so if part A is in C1R1 and Part A is in C2R1 the resuilt would be "AB", if part B is in C2R2 and Part B is in C3R2 the resuilt would be "BC"
Hope this makes sense, I have attached an example to hopefully clarify