Skip to main content

I am trying to add a formula an Excel workbook using AA, but the bot adds the @ symbol making it not work correctly.  Is there a way to use the Set Cell Formula to not include the @ symbol when the bot runs?  

=FILTER(UNIQUE($sMasterDataTabName$!F:F), (UNIQUE($sMasterDataTabName$!F:F) <> 0))

 

Turns into


=@FILTER(UNIQUE($sMasterDataTabName$!F:F), (UNIQUE($sMasterDataTabName$!F:F) <> 0))

Looks like something new that Excel is adding. I also got the “@” and when I went to edit it out, I saw this message:

Apparently there is nothing to worry about.

The “Learn more” button goes here:

https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34?ns=EXCEL&version=90


Reply