QUESTION :
I want to indicate a range of an array in rows and columns, but I don’t want to have to type one by one, is there any way to indicate the array row and column using the formulas: “ROW ()” AND “COL () ?? because it is hard work to type the range manually, the matrix has to be of the type that is in the image. I tried to indicate the ranges and could not get the correct sequence of numbers, okay?
ANSWER :
Use:
{=ROW(C11:D15)+COLUMN(C11:D15)-(13-(ROW()-11))}
adjusted for the language base of your copy of Excel.
The difficulty for your desire is the hard-to-define-a-pattern for reducing the results of the row and column values you are adding. In the simple version shown in the picture, just subtracting 13, say, gives {12;23… instead of {12;34…
You need a reducing amount to subtract so you need to keep reducing the “13” by 1 for each row you carry the formula down. Subtracting the rising quantity ROW()-11 does this.