This project has moved and is read-only. For the latest updates, please go here.

Create Array Formula Fail.

Aug 22, 2014 at 7:30 AM
I try to create an array formula , but it doesn't work, only first cell show the value, others are empty.

code:
worksheet.Cells["E2:E5"].CreateArrayFormula("FREQUENCY(B2:B18,C2:C5)");
Excel:
Image

you can see that Cells["E3:E5"] has array formula but empty.
Help~~~
Jun 15, 2016 at 7:53 AM
I got this issue, the same case, please help me