Easier way to write down this formula

Originally Posted by Mverm0

After i had wrote ";" instead "," it gives "value!" and not the answer.

This is an array formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter. Did you confirm the formula with CSE? If not, select the cell which has formula in it, press F2 (function key), and hold down the Ctrl+Shift and then press Enter.