Dear All
good morning
I have data like this
IND M1 M2 M3 M4 M5
1 A/A G/G C/C T/T T/T
2 T/T C/C C/C G/G G/G
3 C/C T/T C/C C/C C/C
4 G/G T/T T/T G/C A/A
5 G/G T/T G/G C/T A/A
Step1: First i would like to give zero if any M column (2nd Row) from M1 to M5 contains different letters like A/T,A/G,A/C,T/A,T/G,T/C,G/A,G/T,G/C,C/A,C/T,C/G
Step3: MATCHING SINGLE ROW WITH ALL THE ROWS AND LIKE THIS ALL THE ROWS WITH REMAINING ROWS for example Matching B3 with B4,B5,B6,B7 and then matching B4 with B3,B5,B6,B7 and I will do same thing with B5,6 and B7 if matches then 0 otherwise 1 and finally I want to sum all the non matches i.e.1's. Now i would like to repeat same rocedure to columns C,D,E,F
Step3: i would like to get sum of all the one's at bottom of each column from B to F
Here i am sharing example for better understanding of my issue.
https://www.dropbox.com/s/iq7m5a2e4e...0PIC.xlsx?dl=0
Here i tried normal if conditions and i can match one row with other and it is taking lot of time but i want to compare all at one time may be through macro or very good formula. I am requesting you all to help and any help in this regard is highly appreciable.
Thanks in advance
Genetist
good morning
I have data like this
IND M1 M2 M3 M4 M5
1 A/A G/G C/C T/T T/T
2 T/T C/C C/C G/G G/G
3 C/C T/T C/C C/C C/C
4 G/G T/T T/T G/C A/A
5 G/G T/T G/G C/T A/A
Step1: First i would like to give zero if any M column (2nd Row) from M1 to M5 contains different letters like A/T,A/G,A/C,T/A,T/G,T/C,G/A,G/T,G/C,C/A,C/T,C/G
Step3: MATCHING SINGLE ROW WITH ALL THE ROWS AND LIKE THIS ALL THE ROWS WITH REMAINING ROWS for example Matching B3 with B4,B5,B6,B7 and then matching B4 with B3,B5,B6,B7 and I will do same thing with B5,6 and B7 if matches then 0 otherwise 1 and finally I want to sum all the non matches i.e.1's. Now i would like to repeat same rocedure to columns C,D,E,F
Step3: i would like to get sum of all the one's at bottom of each column from B to F
Here i am sharing example for better understanding of my issue.
https://www.dropbox.com/s/iq7m5a2e4e...0PIC.xlsx?dl=0
Here i tried normal if conditions and i can match one row with other and it is taking lot of time but i want to compare all at one time may be through macro or very good formula. I am requesting you all to help and any help in this regard is highly appreciable.
Thanks in advance
Genetist