Array

%3CLINGO-SUB%20id%3D%22lingo-sub-833794%22%20slang%3D%22en-US%22%3EArray%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833794%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20dynamic%20array%20and%20i%20have%20downloaded%20the%20template%20but%20instead%20of%20value%20%23NAME%3F%20is%20coming%20and%20i%20m%20unable%20to%20solve%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epls%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-833794%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edynamic%20arrays%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833804%22%20slang%3D%22en-US%22%3ERe%3A%20Array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402267%22%20target%3D%22_blank%22%3E%40Ams28%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20I'm%20afraid%20you%20do%20not%20have%20the%20proper%20version%20of%20Excel%20that's%20why%20you%20are%20getting%20the%20%23Name%3F%20error.%3C%2FP%3E%3CP%3EAre%20you%20using%20Office%20365%20with%20Office%20Insider%3F%3C%2FP%3E%3CP%3Eif%20not%20then%20you%20can't%20use%20Dynamic%20Array%20functions.%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-833985%22%20slang%3D%22en-US%22%3ERe%3A%20Array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-833985%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20just%20purchased%20it%20%2C%20so%20need%20to%20know%20from%20where%20i%20can%20get%20it%20office%20insider%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3Eamit%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834116%22%20slang%3D%22en-US%22%3ERe%3A%20Array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20get%20Office%20Insider%20from%20their%20website%3C%2FP%3E%3CP%3EInsider.Office.com%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834151%22%20slang%3D%22en-US%22%3ERe%3A%20Array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834151%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402267%22%20target%3D%22_blank%22%3E%40Ams28%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20get%20Office%20Insider%20from%20their%20website%3C%2FP%3E%3CP%3EInsider.Office.com%3C%2FP%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ams28
New Contributor

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.

 

pls help

 

3 Replies

@Ams28 

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.

Good Luck

Nabil Mourad

@nabilmourad 

 

I have just purchased it , so need to know from where i can get it office insider

 

thanks

amit

@Ams28 

Hi 

You can get Office Insider from their website

Insider.Office.com

Good Luck

Nabil Mourad