I just tried that but had no luck. Could it be a setting? This is the formula
{=INDEX(Q1:Q54,SMALL(IF(Q1:Q54<" ",ROW(V1:V54)),ROW(6:6)))}


"bj" wrote:

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?