In article <54dbeb15e609f@uwe, "Sam S via OfficeKB.com" <u4102@uwe
wrote:

Just to clarify: do you mean the shorter version of the Formula in B2 does
not have to be array entered?

No, I meant if you enter an array formula via Insert Name Define
it doesn't have to be array entered.

Cheers!