Need help with the formula

[ArijitRoy]

Hello Friends,

I have attached a input file which includes the instructions about what I required. Only use column A and B as input. Under D column is the output I require and instructions under E column.

Billow pictures of the Formula I have tried but getting error. Tried with ToNumber also. Please help

[binu_acs · Accepted solution]

@ArijitRoy You need to re-write your formula like below

[ArijitRoy]

Thanks @binu_acs. It worked. 😊