Forum Discussion
Solved
Excel XMATCH and FILTER with PowerShell
I am trying to use the FILTER and XMATCH formulas with a PowerShell script but when I open the XLSX files, those formulas are not spilling over to the other rows and columns and have '@' in them. ...
- You need the Formula2 property of the Range object.
You need the Formula2 property of the Range object.
Awesome. Much thanks.
This is working for me now :
$ExcelWorksheet.Cells.Item(2,3).Formula2 = '=FILTER(...)'