{=IFERROR(INDIRECT(“EstimateNotes!A”&SMALL(IF(EstimateNotes!$B$5:$B$80=1,ROW(EstimateNotes!$A$5:$A$80)),ROW(1:1))),"")}
The following array formula does not return any value in Aspose.cells version 7.7.2 but but it returns the proper value in excel:
Hi Seth,
Thank you for contacting Aspose support.
The said problem could be due to some bug in your current version of the API so please give a try to the latest version, that is; 8.6.2.4 at the moment. In case the problem persists with latest revision, please provide us an executable sample application along with the input spreadsheet using the mentioned formula. We will look into it to assist you further in this regard.