Adjust Row Column

This is column one, this is column two. Row one, row two.

Because this row, row 1, column 2.

Row 3, column 3.

First row contains column names

So row 1, column 3.

We multiply this row vector times this column vector to get row 1, column 2, right?

And that row times this column.

Then this row times this column.

This is row 3, column 3.

The ADDRESS creates a cell address. Parameter Row is the row number and Column is the column number.

So now, when we're in row 2, column 1, we cross out row 2, cross out column 1.

Add column names as the first row

So that's in row 1 column 2.

So we eliminated row one, column three.

Then finally, this row times this column.

So it's that row times this column.

Then we're in row 3, column 2.

Because this is row 2, column 2.

This is in row 2, column 1.

Well, you add the element that's in row one column one with the element that's in row one column one.

So, it's in the second row, second column.

The next entry is row 1 column 2.

And then what's the second row, second column?

I cross out row 1 and column 1.

Well you cross out row 1, column 3.

So we cross out row 2, column 3.

OK, so we're in row 3, column 1.

So we cross out row 3, column 1.

So we cross out row 3, column 2.

So you cross out that row, that column.

So you cross out that row, that column.

So it's getting it's row information from the first matrix's row, and it's getting it's column information from the second matrix's column.

So let me construct a 3 by 3 matrix here. Let's say my matrix A is equal to let me just write its entries first row, first column, first row, second column, first row, third column.

Let me see I don't like this color at all and now we're going to multiply this row, because we're in this bottom row, we're in row 2, column 2, to row 2, column 2.

You take the dot product of this column, this row vector with this column vector.

REFERENCE TO COLUMN OR ROW IS OUT OF RANGE

We're going to multiply this row times this column.

I'm going to take this row times this column.

So it is essentially this row times which column?

OK, so then we're in row 2, column 3.

Well this 1 was in row 1, column 2.

Absolute number specifies the type of reference 1 or omitted Absolute, 2 Absolute row, relative column, 3 Relative row absolute column and 4 Relative.

Highlight the current row, column and box in different colors

Now we're going to multiply this row times this column.