:Find and reference functions COLUMN function Mark cell column numbers-Table skills免费ppt模版下载-道格办公

Find and reference functions COLUMN function Mark cell column numbers

Picture and text skills
Case

Returns the column label of the given reference.

Syntax
COLUMN(reference)
Reference is the cell or cell range whose column label needs to be obtained.

￭ If reference is omitted, it is assumed to be a reference to the cell where the function COLUMN is located.

￭ If reference is a cell range and the function COLUMN is input as a horizontal array

The function COLUMN will return the column labels in reference in the form of a horizontal array.

￭ Reference cannot reference multiple regions.

When we are making When creating a table, how to use a function to mark the column number of the cell?
You can easily label using the COLUMN function. The meaning of the COLUMN function is to return the column label of the given reference.
For example: the column number of cell A2 is 1, because cell A2 is in column 1.
Let's practice it to help you master this function.

￭ Taking this student score sheet as an example, we select cell (D10).
Select the insert function and select the COLUMN function.

￭ In the pop-up window, we need to fill in the reference area, which is the cell whose column number is to be obtained.
We click (B10) to try to get a column number, click OK, and it shows that the column number of cell (B10) is 2.

This function is very simple and practical, I believe everyone has learned it!

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/cha-zhao-he-yin-yong-han-shu-COLUMN-han-shu-biao-zhu-dan-yuan-ge-lie-hao.html