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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |