HOW TO FIND DATA IN EXCEL, THANKS

This kind of multi-field conditional query problem is very typical and very common in the process of data processing.

Unfortunately, we find it inconvenient to do it directly with a single function, and there are a few common ways to deal with it:

1.Construct a new column (assuming your data is in column A c, we may wish to put the new column in column D), the content of this column is obtained by merging columns A and B, for example, the formula in D2 is: =A2&B2, and use the formula : where the search results need to be displayed

lookup("Zhao Li"&26,d2:d6,c2:c6) ("Zhao Li"and 26 can also be entered into a cell, which can be replaced by a cell reference in the formula), and the newly constructed excessive column (column d) can be hidden.

2.Filter and set the filter conditions.

3.Find someone to write a user-defined function that uses VBA to query by multiple conditions, and do it all in one go.

Good luck!

The original data are in columns A, B, and C, enter the name of the information to be counted in D2 (such as Xinmin Evening News), and enter "=Countif(C:C,D2)" in E2 (if you want to count all the numbers at the same time, change the formula to "=Countif(C:C,.)."Xinmin Evening News"", the Xinmin Evening News in other formulas is changed to other information ** name).

Taking Excel 2013 as an example, there are the following steps:

1. Open an excel**, as shown in the figure below:

2. You can see that there is a column of data in **, as shown in the following figure:

3. Click the search and selection menu above, as shown in the figure below

4. Select Search, as shown in the following figure:

5. Enter the content you want to find in the pop-up window and click Find All, as shown in the following figure:

6. After clicking, the cell containing the search keyword appears at the bottom, as shown in the following figure:

Excel often needs to use the search function to find data, how to use the search function? The following is the method of finding data in excel** that I bring to you for your reference.

How to find data in Excel:

Find data Step 1: First select a row of data you want to filter, for example, the first row of the header row is generally the first row, and the menu bar - "Auto Filter" under the start menu will be automatically filtered, and then the title will appear.

Find data step 2: You can click on the triangle symbol, and then find it inside, remove all the selections, and then select Oh, but this way once the data is large, it will be dazzling. (looking for it in the sea).

Find data step 3: There is also a custom search, which is mainly for the memory of fuzzy, not very clear about the whole information, and at the same time can also find out the same kind of information (some friends themselves want to find the same kind of information) Remove all the selection, find the data Step 4: However, fill in your own requirements in the filter box, for example, if the information is vague, use * to represent, if it is very clear, select "equals" in front and then determine.

Find data step 6: Because there will be some data that is hidden as soon as you filter it, if you want to return and want to display it all, then you can click on the triangle logo to select all.

Excel often needs to use the function of quick search, how to quickly find in a large number of data? The following is a quick way to find data in Excel** shared by Xuela for everyone to read and learn.

Ways to quickly find data in Excel:

Quick Find Data Step 1: As shown in the figure, we have been to the workbook with less than 15 worksheets, we can directly select them because they are already displayed below, what if there are more than 15 worksheets in the workbook? We can only do it with 4 tab buttons, which is cumbersome.

Quick Find Data Step 2: We right-click on the 4 tab buttons below, and now we can see a series of sheet names, at this time, we click on the sheet name to go to the specified sheet.

Quickly find dataStep 3: Since there are too many worksheets, if we still can't find the worksheet we want, we can right-click on 4 tabs, click "Other Worksheets", open the active document, select the worksheet we need in it, and double-click to enter the worksheet.

Quickly find data Step 4: When there are many documents, it may be difficult for you to find them quickly, at this time, you can find them by keyboard operation, for example, we want to find the "transcript" worksheet, we can press the "C" key on the keyboard, at this time, the activity table is immediately selected"c"Start with the first **, then find the desired **, double-click to open it.

Take a deep breath to prepare, then at the beginning of the hand, eye, and brain in one, press the shortcut key Ctrl+F as fast as possible, and quickly enter the data to be queried, and press enter to find the data.

Note: In order to be "fast", the realm of hand, eye and brain integration should be trained for a long time in order to truly reach the highest level of "man-machine integration" and to carry out data search operations at the fastest speed.

1.You can select 812 in the first row, hold down the Ctrl key, select 812 in the second row, and then select the third row.

2. Click on the conditional formatting of cells.

The cell rule option is displayed, and the rule selects a duplicate value. Set the color and click OK.

Run the following after selecting the region.

sub Find 812 ().

dim rng as range, rng1 as rangeset rng = - 2)

for each rng1 in rng

if rng1 = 8 and , 0) =1 and , 0) =2 then

end if

next rng1

end sub

The first column is conditional formatting.

Step: Add conditional formatting to the first cell:

and(countif(b:b,a2),countif(c:c,a2)) format the font red.

Select the first cell --- format the --- first column.

Find the "Find and Select" icon in the upper right corner of the Excel function bar and select Search.

2.Enter the shed data you want to find, and click "Find All".

3.If you have a large amount of data, you can click Find Next until you find the data you want.

There are two kinds of methods, function method, VBA method, and there are many kinds of function methods, take excel2016 version as an example, other versions are similar, so as to achieve your requirements:

Two tables are simulated, one table is the "operation table", which is used to select different options and find the desired value, and the other table is called "data table" to store data, you can operate according to your actual table, and assume that there are 2000 rows of data.

The insertion point (mouse) is placed in the A1 cell of the "Operation Table" --- data --- data validation.

In the window that appears:

Allow -- to select "Sequence".

In this way, the drop-down option function of the A1 cell is realized

Next, do the second step and find the value that the belief wants

In the C1:L2 region, enter the formula:

This formula has to be entered one by one (of course, you can use the method of pulling to the right, and then modifying) to upgrade:

c1: =vlookup($a$1, datasheet!) $a$2:$v$2000,2,0)

d1: =vlookup($a$1, datasheet!) $a$2:$v$2000,3,0)

C2: =vlookup($a$1, datasheet!) $a$2:$v$2000,13,0)

D2 enters: =vlookup($a$1, datasheet! $a$2:$v$2000,14,0)

A closer look reveals patterns.

Just modify the numbers marked in red.

Let's see the effect:

<> completed.

How does excel accurately find out the best data? Many friends said that it is not easy to find out the data in **, and it is good to compare and find the data one by one! But in fact, this efficiency is very low!

How can we find it quickly and accurately? In order to help you solve this doubt, the following is a detailed step-by-step explanation, let's take a look at the specific operation method!

1.Open the Footage. xlsxfile, select C3:

C22 cell area, press Ctrl+F, or click the drop-down button of the Start Group Find & Select button, and select the Find option from the drop-down list.

2.Open the Find and Replace dialog box, enter "Zhang San" in the Find Content text box, and click the Find All button.

3.You can see the search results displayed below, a total of 6 cells contain "Zhang San", which does not match the required "only 2 words of 'Zhang San'".

4.Click the Options button, select the Options area, select the Cell Match checkbox, select the C3:C22 cell range, and click the Find All button.

Tips: The meaning of the options in the Options area is as follows. [Scope]:

Search Scope]: It contains 3 options: "Formula", "Value" and "Annotation", and its usage will be introduced in the subsection. [Case sensitive]:

When looking up English, if you select this option, it will be case-sensitive, otherwise it will not be case-sensitive. [Cell Matching]: When this option is selected, Socks God will find cells that exactly match the query content in the query area; When not selected, all cells that contain the contents of the lookup query are found.

Distinguish full half width]: The function is to choose whether to distinguish between full width and half width when searching, select this option to distinguish, otherwise do not distinguish. 5.

You can see that there are only 2 cells in the result, hold down the [Shift] key and select the 2 results below.

6.Right-click the 3 cells in the data region and choose the Copy command from the shortcut menu.

7.Select the location you want to copy and press [Ctrl+V] to paste the target cell to the specified location.

About "How does excel accurately find out the best data?" Little Rabbit shared it in detail, have you learned? Learn the method of excel to accurately find out the best data, then the work efficiency can be greatly improved!

What are you waiting for? Why don't you hurry up and learn?

Taking Excel 2013 as an example, there are the following steps:

1. Open an excel**, as shown in the figure below:

2. You can see that there is a column of data in **, as shown in the following figure:

3. Click the search and selection menu above, as shown in the figure below

4. Select Search, as shown in the following figure:

5. Enter the content you want to find in the pop-up window and click Find All, as shown in the following figure:

6. After clicking, the cell containing the search keyword appears at the bottom, as shown in the following figure:

Excel 2016 How to use wildcards to find data.

Method: Open the Find window; Type what you're looking for;

2.Mouse click on the last sheet**; Press and hold the slide button all the way to the left (keep it in the last sheet state during this process);

3.Hold down the shift key and click on the first sheet to select all jobs, and click "Find" in the search window.

Click on the blank gray block in the upper left corner of cell A1.

Press Ctrl+F

Enter the person's name and look it up.

1. You can use CTRL+F to search.

2. You can use the function vlookup.

For example: A1 number, B1 name, C1 age.

Just enter the number to know the name and age. (Enter the number in cell d2, e2 returns for name, f2 returns for age).

e2=vlookup($d$2,$a$2:$a$30,2,false)

f2=vlookup($d$2,$a$2:$a$30,3,false)

If you don't understand, you can ask.

If there is data in the list of qualified candidates, such as ID card, mobile phone number, etc., you can use the countif function to get it immediately.

Use the search function in Ctrl+F to enter the person's name, and you will find it out quickly.

Ctrl+F, click Options, select Workbook, and enter what you are looking for