Is it possible to create Array Formulas/CSE formulas when manually creating an excel file?
I have uploaded a sample that demonstrates both methods. Please let me know if you have any further questions.