Excel looks for the rows of data in a column

Suppose you know the cell position of Excel for example: af50, and you want to jump to this cell quickly.

1. On the left side of the excel column, directly type: af50, press enter.

See Figure 1. 2. The effect is shown in the figure, the AF50 cell will be selected, and it will automatically jump into the Excel display window.

See Figure 2. 1. Select the column you want to find.

2. Select [Data] in the menu bar - > filter ] - > Auto Filter] 3. An inverted triangle button will appear in the first cell of the column, click this button to select the value to be displayed in the drop-down list, or you can select [Custom] to specify the search conditions in the form that appears.

Based on the study of the stratigraphic sequence and sedimentary facies of the Yadan on the water, the age of stratigraphic formation, and the tectonic conditions, climatic conditions and human factors that evolved into the Yadan landform after stratigraphic formation in the Yahu area of the Qaidam Basin in Qinghai Province, it is concluded that the strata constituting the Yadan in the study area are the Miocene Upper Yadshan Formation, and the mesozoan assemblage contained in it indicates that its formation age is the late Miocene. The analysis of sedimentary facies and pollen assemblage revealed that the paleolac environment in this area was a warm and arid climate in the late Miocene, and the lacustrine facies and lake delta fronts were deposited. In the Pliocene, under the dual effects of regional tectonic uplift and arid climate, the paleolakes gradually shrank. In the Pleistocene, the upper strata of the Shangyoushashan Formation, which was uplifted to the surface, were formed under the action of external forces dominated by wind erosion. Late Pleistocene-HoloceneDue to the arrival of the last interglacial period, the climate turned warm and humid, and the lake water invaded again. In recent years, human activities have changed the distribution pattern of the lake, resulting in the lake submerging part of the land Yadan, presenting a peculiar water Yadan landform landscape.

Your physical life exists, from the outside to the entire universe, the void, and even the planets, the earth, and the whole world, all of which are really like a little image in your heart. You see how big this is really like a heart.

1. Know the name and its corresponding monthly income in Table 1.

2. Now you need to find the corresponding actual monthly income of some people in Table 1. Table 2 shows that when it is inconvenient to search one by one due to a large number of data, it can be eliminated to make the formula vlookup in excel quickly find and match the corresponding data.

3. First of all, you need to set the cell format, and format the search column (column b, column C and column D) in Table 1 and the search column (column F) in Table 2: data - column.

4. Find the separator symbol and click Next.

5. Format the cells that need to be inserted into the matching value column (such as the g column in Table 2): right and click the forward key to set the cell format.

Excel popular tutorials recommend Excel (2016-2019) workplace practical introduction to mastery tutorials.

Excel-Electronic** Function Practical Tutorial.

Excel** beginner to quick mastery.

Play Excel's zero-based introductory lesson.

School office excel skills use tutorial.

Excel-Electron Pivot Table.

Excel is a well-known software, mainly used for data processing, this should be the software that everyone in the workplace will use. However, there are still many people who can only use some basic functions of Excel, or can not use the functions of Excel data processing, for this reason, some professional tutorials of Excel are provided, including basic introduction, common use in the workplace, office skills, chart drawing, etc. For example, the very popular "Excel (2016-2019) Workplace Practical Introduction to Mastery Course", this tutorial includes introductory chapters, function chapters, charts, perspective charts, etc., and you can be proficient in almost all operations of Excel after learning.

Yutu also has other office software tutorials, such as word, ppt, wps, etc., if you want to learn office software systematically, you can take a look.

Excel is a way to view up to a few rows and columns.

1. Open an excel file, or create a new blank file;

2. Convert the column name into a number first, and click the menu item [File] - [Options] in turn;

3. Click [Formula] in the "Excel Options" interface, tick [R1C1 Citation Style], and then [OK]; Leakage.

4. After it is determined, the column name will be displayed as a number;

5. Press [Ctrl+Down arrow key], the cell will be selected to the last row, and you can see what the row number on the left is, which is the maximum number of rows;

6. Press [Ctrl+Right Arrow Key], the cell will be selected to the last column, and you can see the column number, which is the maximum number of columns.

Tools Material: Microsoft Office Excel 2016 Edition, Excel**.

1. First, select Excel** and double-click to open.

2. Secondly, in the interface, select the cells that you want to display how many items there are in a column. Mausoleum accompaniment.

3. Then, in the interface, enter the Hu Qi formula "=count(a:a)" to calculate how many items are in a column in the above publicity box.

4. Secondly, in the interface, click the "OK" button on the left side of the publicity box.

5. Finally, in the interface, a single ruler does stupid yuan to show how many items are in a column.

First check excel ** and double-click to open it.

Secondly, in this interface, select the cell that you want to display how many items there are in a column.

Then, in the upper publicity box, enter the formula "=count(a:a)" to calculate how many royal change items there are in a column.

Secondly, in the town file interface, click the "OK" button on the left side of the publicity box.

Finally, in this interface, the cells show how many items are in a column.

Summary. Hello dear, I am glad to answer for you how to find a few values in a column and multiple rows in excel? Find multiple specified values in a column of data at the same time and identify them, you can use conditional formatting, as follows: 1. Select column A, as shown in Fig:

How to find several values in a column and multiple rows in excel.

Hello dear, I am glad to answer for you how to find a few values in a column and multiple rows in excel? Find multiple specified values in a column of data at the same time and identify them, you can use conditional formatting, as follows: 1. Select column A, as shown in Fig:

3. Use the formula to determine the cells to be formatted, enter the formula: =or(a1="Zhang San",a1="Li Si",a1="Wang V"), and finally click "Format", as shown in the figure

For example, on line 999, enter a999 in the Name box

Press Enter to navigate to line 999.

Please click Enter a description.

The solution of how to quickly find the first few rows in excel is as follows:

1. Name box method, after Excel is opened, there is a name box on the left side of the input box, directly enter the name of the cell and press enter. For example, if you think of line 18, then type a18 and press enter to skip directly to line 18.

2. Positioning method. Press Ctrl+G to open the Locate dialog box, and enter the line number in the location area. For example, if you think of line 18, then type a18 and press enter to skip directly to line 18.

There is a box to the left of the place where you entered the formula, which shows the cell you are currently selected. Enter the cell you want to locate in this box to achieve quick positioning.

For example, if you enter A1000 and press Enter, it will immediately go to the A1000 grid.

You can see the numbers A1 and B1, change the line you are looking for here, for example, A987 is the 987th line of column A.

Let's say you want the data to be in column A and the data you want to find is in F1

The array formula ctrl+shift+enter.

If there is no duplicate data in the original table, you can directly use =sumproduct(($b$1:$e$3=$a 8)*row($b$1:$e$3)) to return the row number where the lookup value is located.

Then use the index function to return the value of column A: =index($a$1:$a$3,sumproduct(($b$1:

e$3=$a 8)*row($b$1:$e$3))) pull-down fill to get the following figure.

If there are duplicate values, change the formula to =index($a$1:$a$3,sumproduct(max(($b$1:

e$3=$a 8)*row($b$1:$e$3))) always returns the last row of the first column of values that match the criteria.

I don't understand the problem. It's all a guess.

Let's say your table 1 is named sheet1

And your data is a1:e3

Then you enter it in Table 2b1.

if(countif(sheet1!b1:e3,a1),index(sheet1!

a1:a3,max(if(sheet1!b1:

e3=a1,row(a1:a3)))

After entering. You can't press enter, but press Ctrl+Shift+Enter to automatically add {} before and after the formula in the column.

Of course you type 23 in A1 and it shows B

34 shows c

Does it mean that the numbers in column A in Sheet2 are in column D in Sheet1, and now we need to find the value of column A in Sheet1 based on the numbers in this column?

Enter =A1 in F1 in Sheet1 first, drop down and copy =VlookUp(A1, Sheet1!) in B1 in Sheet2d:f,3), pull-down copy.

In this way, when A1 appears 23 in Sheet2, B1 will appear B

Exactly the cell you want to find for a certain value.

Or to return a value.

How is it possible to do 2 things in one formula?