Dear All, With reference to the following formula that I used in the attached sample file. Can you please elaborate the logic of “1” highlighted with red colour?