Hi to all,
I have data like this,
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
Now i want to select member column values based on the differences in values between members of location column should be 50000, it means if select web then my next selection should be SEB because next value (i.e web + 50000) is 100000 and it is matching to SEB in members column.
expected results
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
I need help to solve this problem and i tried with normal if formulas but not getting expected results. Any help would be appreciated,
Thanks in advance,
Regards,
Genetist
I have data like this,
Member | chr | location |
web | 1 | 50000 |
reb | 1 | 30000 |
seb | 1 | 100000 |
keb | 1 | 150000 |
geb | 1 | 200000 |
deb | 1 | 40000 |
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
Now i want to select member column values based on the differences in values between members of location column should be 50000, it means if select web then my next selection should be SEB because next value (i.e web + 50000) is 100000 and it is matching to SEB in members column.
expected results
web | 1 | 50000 |
seb | 1 | 100000 |
keb | 1 | 150000 |
geb | 1 | 200000 |
<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY>
</TBODY>
I need help to solve this problem and i tried with normal if formulas but not getting expected results. Any help would be appreciated,
Thanks in advance,
Regards,
Genetist