When the Res = "Comprehensive Epilepsy" and I step through the code
iHomopolymer = 43 (this value doesent make sense)
the way the formula should work is:
Q5 = 1 and R5 = 40556922
so those two values are used to search in panel in the ranges indicated and what results in the Homopolymer column is "No" because a match was not detected. If a match was detected the result in Homopolymer would be something like "9A" or "5C".
Below is the manual formula I used to use each time (and what I hope can be automated)
The ranges in the formula are different, but the idea is the same. Thank you for your help.
Bookmarks