Since you copied/pasted the formula into your workbook, it's possible
that a hard return may have been added. Try typing out the formula
instead. Does that help?

In article ,
SOS wrote:

Domenic,

Thanks for the reply. I pasted your example into my workbook as an
array formula (CTR+SHIFT+ENTER) but ended up with #NAME? Error in the
cell.

Any ideas?

Seamus