No I just copied and paste the formula. I'll try this

"Harlan Grove" wrote:

Have you entered the formula as an array formula, holding down [Ctrl] and
[Shift] keys before pressing enter?