Hi,

The following formula works as intended:

{=IF(COUNTIF($N$1:$N$1000,"?*")<ROW(N2),"",INDEX(N $1:N$1000,SMALL(IF($N$1:$N$1000<"",ROW($N$1:$N$10 00)),ROW(N2))))}

Now I want to insert it into another workbook so that the results are
displayed there also. Here I have modified the formula for this purpose:

{=[Flex_connection.xlsm]Names!O2,IF(COUNTIF($N$1:$N$1000,"?*")<ROW(N2),"", INDEX(N$1:N$1000,SMALL(IF($N$1:$N$1000<"",ROW($N$ 1:$N$1000)),ROW(N2))))}

This formula returns a #VALUE! error.

Anyone got any idea what I am doing wrong. Much appreciate any help given.