Hi all,
I am newly joined in this forum, I need help in solving this problem, my data looks like in my uploaded file
I want to write IF condition to check for dummy SX1 whether P1 & P2 contains same letters or not, for this i written IF condition like this
=if(G2=G1,"Equal","notequal") It means both G1 and G2 contains same letters for example GG, GG then it will give equal. I want to write IF condition for notequal condition for the cells contains even Z/Z also.
Expected result is
1 Parent SX1 SX2 SX3 SX4 SX1 SX2 SX3 SX4
2 P1 AA GG Z/Z //
3 P2 AA GG GG AA EQ EQ NE NE
This is my if condition =IF(E1=E2,"EQ","NE"), but this condition giving NE for example SX3 and SX4 but i want those should be EQ. How can i write if condition in this situation?
Thanks in advance
Regards
Bookmarks