Hi to all, i need help in solving my problem,
My data looks like this
i.d m1 m2 m3 m4 O1 O2 O3 O4
p1 aa gg -/- z/z mono poly poly poly
p2 aa aa tt cc
i written if condition like this in blank O1 cell =if (P1=P2,"mono","poly") and i got mono for m1 in O1 cell,poly in O2 cell,poly in O3 & O4 for m3 and m4 cell values, but i want to give mono for m3 and m4 values (-/-,z/z) in O3 and O4 columns. -/- and z/z are the type of missing values thats the reason i want to give them as mono.
my output looks like this
<TBODY>
</TBODY>
My data looks like this
i.d m1 m2 m3 m4 O1 O2 O3 O4
p1 aa gg -/- z/z mono poly poly poly
p2 aa aa tt cc
i written if condition like this in blank O1 cell =if (P1=P2,"mono","poly") and i got mono for m1 in O1 cell,poly in O2 cell,poly in O3 & O4 for m3 and m4 cell values, but i want to give mono for m3 and m4 values (-/-,z/z) in O3 and O4 columns. -/- and z/z are the type of missing values thats the reason i want to give them as mono.
my output looks like this
i.d | m1 | m2 | m3 | m4 | O1 | O2 | O3 | O4 |
p1 | aa | gg | -/- | z/z | mono | poly | mono | mono |
p2 | aa | aa | tt | cc |
<TBODY>
</TBODY>