I have an array formula that is returning an error of #VALUE when it
shouldn't.The formula is below.
{=ISERROR(INDEX($'Sales
4-10-2017'.$A$1:$A$1000;SMALL(IF(ISERROR(FIND("Discount";$'Sales
4-10-2017'.$A$1:$A$1000))=0;ROW($'Sales
4-10-2017'.$A$1:$A$1000);"");ROW(A200}
Digging into it, it s
Hi,
The purpose of FIND is to get the position of a substring in a longer
string. What do you want to achieve? The use of FIND in an array
function looks strange.
Kind regards
Regina
ouch schrieb:
I have an array formula that is returning an error of #VALUE when it
shouldn't.The formula is
ible Formula Bug in Calc? (IsError and Find)
I have an array formula that is returning an error of #VALUE when it
shouldn't.The formula is below.
{=ISERROR(INDEX($'Sales
4-10-2017'.$A$1:$A$1000;SMALL(IF(ISERROR(FIND("Discount";$'Sales
4-10-2017'.$A$1:$A$1000))=
2:31 AM
To: dev@openoffice.apache.org
Subject: Possible Formula Bug in Calc? (IsError and Find) I have an array
formula that is returning an error of #VALUE when it shouldn't.The formula is
below.
{=ISERROR(INDEX($'Sales
4-10-2017'.$A$1:$A$1000;SMALL(IF(ISERROR(FIND("Discount";