Question

Setting array formula using excel advance package

  • 30 May 2023
  • 0 replies
  • 29 views

Badge

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)


0 replies

Be the first to reply!

Reply