I am new to dynamic array and i have downloaded the template but instead of value #NAME? is coming and i m unable to solve it.
Hi I'm afraid you do not have the proper version of Excel that's why you are getting the #Name? error.
Are you using Office 365 with Office Insider?
if not then you can't use Dynamic Array functions.
I have just purchased it , so need to know from where i can get it office insider
You can get Office Insider from their website