Forum

Further, you are kindly requested to explain, How this overall formula works please. That will be a great help ! thanks & great regards.

Simply, Marvelous. Working perfectly. I entered the formula as "Array Formula" by "CTRL+SHIFT"..ENTER. Working. But giving 0 if we do not enter as ...

In the attached sample file, x & y being variables are distributed in the table. The No written in front of variable is the value of that variable...