square matrix determinant

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

Your title suggests you are doing this to calculate the matrix determinant. Unless there is some reason to not use the build in function, I would probably use the MDETERM() function to get the determinant without needing to get at each element of the matrix: https://support.office.com/en-us/art...1-0ffd03717020

If you are doing something other than the standard determinant, or you need access to each element of the matrix, the INDEX() function is usually how one would extract a single element of the matrix: https://support.office.com/en-us/art...2-b56b061328bd =INDEX($A$1:$C$3,2,1) would return the value from A2.

Beyond that, I am not sure I understand what you are trying to do. I would expect those functions would be involved whatever you are trying to do. You might also look into PowerPivot to see what "data manipulation" functions it contains. It might be useful to see what tools are in PowerPivot that will apply to your desired task(s).