When I write this formula “=FILTER(SEQUENCE(ROWS(A:A)),(D:D=$K$2)*(F:F=$J$2),”“)” in excel using write cell activity I’m getting below error. Can someone please help me with the syntax? What is the right format here?
Excel Application Scope: The write operation failed, because one of the following reasons:
► The data you want to write “=FILTER(SEQUENCE(ROWS(A:A)),(D:D=$K$2)*(F:F=$J$2),”“)” has a wrong format;
► Excel is busy;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.
I tried with saving the formula in .txt file, reading the formula from .txt and stored in a variable.
Write that variable in excel, still having the same format error.
I am out of options ;-(
Finally, figure out the cause of the issue.
It is the Excel version, currently Filter Function only available for Office 365 subscribers.
I realized that our development environment excel version was Standard 2019. That is the reason I was getting that wrong format error.