You can view a video on this technique below and download the Excel worksheet here. The result is that each time the formula is copied to the right, the formula references the next row down on the amortization schedule. As this formula is copied to the right, the COLUMN function references cells C1, D1, E1, and so on, which equates to columns 3, 4, 5, and so on, respectively. Therefore, in our INDEX formula, instead of typing the numeral 2 to reference row 2, we can instead type the COLUMN function =COLUMN(B1), which returns the numeral 2. The beauty of this formula is that when copied to the right, the value returned increments by one each time, so that the COLUMN function essentially becomes a counting tool. For example, the formula =COLUMN(A1) returns the value 1 because cell A1 is located in the first column. Excel's COLUMN function returns the number of the column in a referenced cell. ![]() As a simple example, the formula =INDEX(A1:F10, 4,4) would return the value in the fourth row of the fourth column in that specified data range. ![]() Excel's INDEX function allows users to reference values in a range of data (or array of data) by their column and row number position within that range.
0 Comments
Leave a Reply. |