Teach you how to rank the building number? excel how to sort the building number in descending order

There are two common numbering methods used by developers, the first is the number of numbers obtained when ranking, which is the number of numbers when choosing a house; Another way to rank numbers is the lottery, the number of numbers that are shaken on the spot, that is, the number of numbers when you choose a room.

In addition, no matter which numbering method is used, it is necessary to pay attention to the following situations:

1. From the azimuth:

When the buyer is looking at the house, he can determine the basic orientation of the building according to the sand table of the sales office. Many northerners like to sit in a house facing north and south, which faces plenty of sunlight, warm in winter and cool in summer. Although there are slight disadvantages in other orientations, we can avoid the disadvantages through later renovation and transformation.

2. From the spacing of the building:

When buyers choose a suitable building in the same community, they must consider the spacing between buildings, if the spacing between buildings is too small, even if they sit north and face south, the house will not receive sunlight.

There are four major precautions for numbering.

1. Analyze the numbering situation.

Ranking is a common method used by developers to confirm the market situation, and is used to determine the number of ** launched. Under normal circumstances, developers will deliberately create the illusion of "** in demand", and the common method is to issue platinum cards.

Internal bookings, numbering, etc., give buyers a sense of urgency.

In the numbering, you can judge the tight situation by observing the atmosphere of the scene and the expression of the salesman, in addition, you can also look at the sales control table displayed by the developer when opening, and the sales control table can go straight to the sales of the house.

2. See through the "blinding method".

In practice, the number of numbers given by the developer far exceeds the number of **. The developer will use the method of lottery, so that once the buyer wins the lottery, he will be as happy as if he has won the jackpot. Psychologically, it has broken the defense line of the buyers, and they just want to pay the money to buy the house as soon as possible, so that the process of buying the house is smoother.

In fact, in most cases, ** is not as nervous as everyone feels, these are just the "tricks" used by developers to sell real estate.

Building (building), unit, household number compilation order: building (building) number. First, there is the street number, and then the building (building) number, starting from the entrance of the residential area, from left to right clockwise floor by floor.

If it is built along the street and does not form a courtyard, the building number can be numbered in order along the direction of the road. On the first floor, there is a building (building) number. Unit grade.

There is a building (building) brand first, and then a unit number. If there are several units in a residential building (building), there are several unit numbers, and the unit numbers are arranged in order from left to right; Buildings with only one unit are not numbered. No unit number shall be arranged consecutively between buildings.

Household number. The household registration cards of each household in the unit are usually compiled in a clockwise direction from left to right from the first floor to the top floor in the order of serial numbers. The arrangement of the elevator apartment number is arranged by "floor number - serial number", such as -3 ...... on the first floor, the second floor is -3......etc., compiled by analogy. ，。

Select the building number column or row, click Data-Sort-Ascending (or Descending), the default is Column, if it is a row, you need to choose to sort by row.

Although it is necessary to use the data sorting function, it is estimated that since the landlord asked, the so-called [sorting] must have something unusual. So, please use a concrete diagram with row and column labels, reference the cells in the description, and explain the results you need to describe your problem more clearly. Your questions will be easier to get faster and better answers!

In Excel, the building numbers are arranged in numerical order, and the specific steps are as follows:

1. The first step is to open the required excel**, as shown in the figure below.

2. In the second step, select the cells that need to be sorted, and then click to open "Data". Next, click and select the "ascending" icon in the pop-up window, and the problem will be solved, as shown in the figure below.

1. Copy column A to column B.

2. Column B is divided into [data] Column 3 and column B are divided into 3 columns according to the separator - number, assuming that they are the unit number, the staircase number and the room number. Select the data area of column A:D, click [Data] to sort, and sort according to the primary, secondary, and third keywords in the three columns

Sort after sorting

Select the building number column - Data - Column - Separate by symbol - Other symbols: - The display area is selected next to it.

At this time, it will be divided into 1, 1, 101, so that the three columns of data will be sorted together with column a.

You can put it in whatever column you want.

Without a function, select the entire data, select the menu "Data" - >Sort", and choose to sort the building number data in ascending or descending order.

Isn't it okay to use ascending and descending order directly?

1. After opening Excel**, click on the cell to make it enter the state.

2. Enter the data in the cells in turn, and the input can be complete.

3. Select the cells you want to sort, and then click the data option above.

4. Click the ascending button on the left side of the sort button, and the data will be arranged in order from smallest to largest.

5. At this time, you can see that the data has been arranged in ascending order.

1. Copy column A to column B.

2. Column B is divided into [data] Column 3 and column B are divided into 3 columns according to the separator - number, assuming that they are the unit number, the staircase number and the room number. Select the data area of column A:D, click [Data] to sort, and sort according to the primary, secondary, and third keywords in the three columns

Format the cells, number = custom = type set to:

Do not enter data with "-".

If it is the original data, use search and replace to remove all the "-", and then format it, and then you can sort it normally.

Use the auxiliary column, insert 3 blank columns after the building number column, copy and paste the building number column to the first blank column, and then paste the pasted column according to it"-"The data is sorted according to the three inserted columns, from smallest to largest.

The number is generally a means of the developer, generally let the buyer pay the intention to do a card, first to the part of the real estate to be sold, and then use the number machine to automatically select the number, each person will choose a number, in order to see the house in turn.

Select the data region, sort, column e, ascending.

If you can't see clearly, take the problem as the content (the subject of the email must contain "excel", and I will use this as a basis to identify non-spam emails to avoid accidental deletion), and send the excel sample file (showing the current situation and target effect) as an attachment to see it.

Hello: The building number in the community is before the construction of the community, generally decided by the developer, there will be a project plan, there will be a call project layout plan, the layout drawing on the building number is clear, in order to be in the future construction, can be clear project distribution, division, good project classification, and then calculate the construction period, schedule, capital arrangement, sales and so on.

The project is divided into four categories: construction project, unit project, sub-project, and sub-project.

As a community, it is a construction project, a single building is a unit project, a building has civil engineering, water and electricity, HVAC and other sub-projects, and a sub-project is a civil sub-project with steel bars, concrete, masonry, and other sub-projects.

A unit refers to a unit project. In the community, it means the building number.

The above is my simple opinion, I hope to give you a little reference, it is my greatest honor to help you.