I am getting a leading ‘@’ symbol whenever I am trying to put an array formula using Set Cell Formula command from excel advanced package. A360 automatically converting array formula to scalar formula. I tried to using Set Cell command but not working. I even tried various string operations to replace ‘@” sign but not successful.
Is there any solution to set an array formula in excel using A360?
Note: Array formula used is =UNIQUE(A:A,0,0)