1) You've pasted the original formula I gave into row 3. As I said in my original post:

Quote Originally Posted by XOR LX View Post
The (non-array) formula in e.g. E2 is then:
2) The Name you've created in Name Manager is called array1, yet that in the formula in Arry1. As I said:

Quote Originally Posted by XOR LX View Post
With the active cell in the worksheet somewhere in row 2 (important), go to Name Manager and define a new name, Arry1 say, as:...
3) You've added the formula for this Named Range into the Comment: box: it should be in the Refers to: box. Apologies - I should've given clear instructions re this.

Regards