hi to all,
i have data like this
sx1 sx2 sx3 sx4 sx5
p1 -/- ZZ AA TT ZZ
p2 AA TT AA TT CC
and i am expecting data like this
sx1 sx2 sx3 sx4 sx5
p1 -/- ZZ AA TT ZZ
p2 AA TT AA TT CC
expected AA TT AA TT CC
i mean i want to compare P1 with P2 from SX1 to SX5 and i want to get common data from either P1 or P2 no matter really from which cell (like in my expected row), but i want to get value if any one of P1 or P2 contains -/- or ZZ then i should get value from eihter of P1 or P2 i mean not to get either ZZ or -/-. (like in my expected row).
I need help to solve this problem help would be appreciated
Thanks
i have data like this
sx1 sx2 sx3 sx4 sx5
p1 -/- ZZ AA TT ZZ
p2 AA TT AA TT CC
and i am expecting data like this
sx1 sx2 sx3 sx4 sx5
p1 -/- ZZ AA TT ZZ
p2 AA TT AA TT CC
expected AA TT AA TT CC
i mean i want to compare P1 with P2 from SX1 to SX5 and i want to get common data from either P1 or P2 no matter really from which cell (like in my expected row), but i want to get value if any one of P1 or P2 contains -/- or ZZ then i should get value from eihter of P1 or P2 i mean not to get either ZZ or -/-. (like in my expected row).
I need help to solve this problem help would be appreciated
Thanks