Alan Beban has a downloadable Excel file chock full of array functions. He’s written these functions in VBA to allow you to maniupulate arrays.
From Alan’s site:
The file “Array Functions” contains 27 Function Procedures and 2 Sub Procedures for manipulating arrays (and worksheet ranges).
The best part is that the code is unprotected so you can see (and learn) what’s going on. Alan probably knows more about working with arrays than anyone. He’d have to just to write these functions. Check them out if you work with arrays.