Dear Experts,

                      I have a data like below(attached sheet as well):-

Column “B” so(Segment Offset) is calculated as the sum of Column “F” and “G” only when Column “A”

is either MID or LAST, I tried to do the below formula in H2, but got #VALUE error, what wrong am I doing here? Could you please share..

Thanks in Advance,

Br,

Anupam

​Dear Experts,                      I have a data like below(attached sheet as well):-Column “B” so(Segment Offset) is calculated as the sum of Column “F” and “G” only when Column “A”is either MID or LAST, I tried to do the below formula in H2, but got #VALUE error, what wrong am I doing here? Could you please share..Thanks in Advance,Br,Anupam   Read More

​