There are some array formulas on a file. I open it then see the array formulas turned out regular formulas, then I fix them, close the file.
Then open it and see they are regular formulas again. How to fix that?
There are some array formulas on a file. I open it then see the array formulas turned out regular formulas, then I fix them, close the file.
Then open it and see they are regular formulas again. How to fix that?
Can you upload that problem file?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
The range E5:E15 contain array formulas however curly brackets will be gone when you fix those and save the file and open it again.
No problem here. Array formulae remain array formulae
E9:E15 are not required to be array formulae.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks