Compare two columns in excel?

Plz help me how to compare the data in two columns in MS Excel. My data is like this: a1 34, a2 35,a3 36,b1 37, b2 34,b3 38, b4 36. a1 has to compare b1,b2,b3 and give the result in C as unique, like wise a2 has to compare b1,b2,b3 and a3 with b1,b2,b3

• Answer:

  I tried this formula and this works perfectly. In column C, type this formula IF(ISNA(MATCH(A1,$B$1:$B$3,0)),"Unique","").... This formula is written considering your data runs for 3 rows. Extend the range if more data is there. In case the data in Col A is not there in Col B, it'll show as "Unique", exactly what you want.