from {your} title I asssume the formula is an array formula
It needs to be entered with control-shift-enter

"Alex" wrote:

About a year ago I got a formula from this site and was told that when I hit
enter I needed to do something else to make it work. It worked great at the
time but now I want to do it again and forget how. Can anyone help me?