PowerShell to Excel: Getting '@' in Formula - ?

Question

I am trying to run an “=FILTER(…)” formula created in a PowerShell script that should spill over and use additional rows and columns. But it is not. Instead I get “=@FILTER(…)” in the cell.

I can manually remove the “@”, press enter, and the formula works.

So, why do I get the ‘@’ ?

My code:

$a = 2
$b = $rec_count
$c = (import-csv $File).count + 1

$ExcelWorksheet.cells.Item(2,3).Formula = ‘=FILTER(ALL!A’+$a+’:K’+$b+’,ISNUMBER(XMATCH(ALL!G’+$a+’:G’+$b+’,“CLOSE”)+XMATCH(ALL!E’+$a+’:E’+$b+’,A’+$a+’:A’+$c+’)+SEARCH(“auto closed duplicate”,ALL!C’+$a+’:C’+$b+’)))’

Any help and/or advice would be greatly appreciated.

Thanks.

Answer 1

Hi,

This could be helpful.
Implicit intersection operator: @

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Yes, thank you. That does explain the @ better than anything I was able to find.

And I was able to get the fix for my problem here:

https://forums.powershell.org/t/getting-filter-in-excel-from-powershell-formula/16648