State about ARRAY

     

  • Arrarys are used when we want to refer the data in range cells instead or single range

    •  

  • Convert the data into Array format we use CONTROL + SHIFT + ENTER

    •  

  • ARRAY formula enclosed with brackets

    •  

     

     

Hi Everyone,
Welcome to Excel Functions Tutorial. This Tutorial provides comprehensive knowledge on Excel formulas to the user. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli