Essentially, excel is a functional language, without the ability for recursion. If there were a built in array datatype, that'd be possible. There's a few papers floating around explaining an integration between Haskell and excel, described in some places as hsExcel, but I haven't seen a working copy.