Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula returning an error
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP returning a #VALUE! error and I've not idea why! HELP!!! | Excel Worksheet Functions | |||
SEARCH function returning #VALUE! error | Excel Discussion (Misc queries) | |||
SUMPRODUCT formula returning #VALUE! error | Excel Worksheet Functions | |||
Custom function returning VALUE error | Excel Discussion (Misc queries) | |||
Formula returning #N/A Error---why??? | Excel Worksheet Functions |