automatically detect the size of a number set?

[Leighton Durham]

Allow me to explain im trying to make an automatic matrix calculator where you can input any size of matrix and it will automatically detect it i currently am using a manual input for the size of the matrix but i want it to be automatic

dose anyone have any ideas of how i can detect the square size? this is the current layout

 

[jasonb75]

For matrix A, you could use

=MACTH(1e+100,B2:B11) and =MATCH(1e+100,B2:K2)

then apply similar to the other matrices. Note that this will show an error if the matrix is empty.

 

[Leighton Durham]

For matrix A, you could use

=MACTH(1e+100,B2:B11) and =MATCH(1e+100,B2:K2)

then apply similar to the other matrices. Note that this will show an error if the matrix is empty.

how exactly dose this work? i dont exectly understand the MACTH function

 

[jasonb75]

First formula goes in J13, second one in K13.

 

[Leighton Durham]

First formula goes in J13, second one in K13.

Invalid Name?

 

[jasonb75]

It was a typo, should be MATCH, not MACTH

 

[Leighton Durham]

It was a typo, should be MATCH, not MACTH

Yes Thank you very much for your time

 

[jasonb75]

You're welcome

Are you able to edit that to fit the second matrix?

 

[Leighton Durham]

You're welcome

Are you able to edit that to fit the second matrix?

already done