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.
Thank you in advance.