Quickly set up building and room number information for real estate in Excel

Recently, many colleagues have asked how to quickly set up a real estate in Excel building and room number information. For this issue, you can use the COULMN function in conjunction with the row function, as follows:

The column function returns the label for the given reference.

Syntax form COLUMN (Reference)

Parameter Description Reference is the cell or range of cells for which you want the column labels. If reference is omitted, it is assumed to be a reference to the cell that contains the function COLUMN. If reference is a range of cells, and function COLUMN is a horizontal array array: A single formula that can be used to generate multiple results or to operate on a set of parameters arranged in rows and columns. The array range uses a formula; An array constant is a set of constants that are used as arguments. Input, the function column returns the label of the column in the reference as a horizontal array. Reference cannot reference multiple regions.

Example explanation in the sale of real estate sales data management process, usually by building, unit, the way of the room management, at this time can use column function and IF, mod function implementation.

(1) Enter the corresponding data content in the A1:a2 area.

(2) Select B1 Cell and enter the formula in the Edit bar: =if (MOD (CO lumn (), 2) =0,column ()/2& "Building", ""), press ENTER to get results: 1th building,

(3) Move the cursor to the lower-right corner of the B1 cell, after the cursor becomes a cross, hold down the left mouse button and drag to the right to fill the formula

Tip 4: Use the column function to develop cell information

Example explanation in the sale of real estate sales data management process, usually by building, unit, the way of the room management, at this time can use column function and IF, mod function implementation.

(1) Select B2 Cell, and enter the formula in the Edit bar: =if (LEN (B1) <>0,left (b1,1), left (INDIRECT (2,colu MN ()))) & "-" & (MOD (COLUMN (), 2) +1), press ENTER to get results: 1-1,

(2) Move the cursor to the lower-right corner of the B2 cell, after the cursor becomes a cross, hold down the left mouse button and drag to the right to fill the formula