Forum Discussion
Excel Dynamic Formula
I added a formula to a cell using EPPLus C# as below. mySheet.Cells[rowNumber, columnNumber].CreateArrayFormula"UNIQUE(FILTER({sheetName}!C:C,{sheetName}!B:B = A{rowNumber}))")); When I open the ge...
You CreateArrayFormula, my guess it's the same as manually add formula with Ctrl+Shift+Enter. It will be with curly braces and returns only first element of dynamic array.
Try to create regular formula, not array one.