About Excel stuff, master please. 60

For example, Table A. a b

Wang 10, Li 20

Table B. a b

Lee =vlookup(a1,a!a1:b10,2,0)=20 kings. That's what it means, and it mainly uses the vlookup() function.

This can be done with the vlookup function.

You can email us and take a look.

It can be achieved with the vlookup function, there is a problem.

<><1.The data is summed in one second.

To calculate the total sales volume in the table below, enter the sum function and select the summing region.

2.Date for quick entry.

Enter the current date:

Select a cell and press [Ctrl] and [; ] two shortcut keys.

Select the cell and press [Ctrl] [Shift] [; Three shortcut keys.

3.ID card information extraction.

Based on the ID number, manually enter the birthday of the first person. Then press the shortcut key [Ctrl+E] to quickly fill in the source rotten and automatically extract other people's birthdays.

4.Super table creation.

The shortcut key [Ctrl+T] converts ** into a super table to quickly beautify the data.

5.Enter the same data in batches.

For filling the same data, in addition to dragging and dropping, you can also use the shortcut key Ctrl+Enter] !

6.Add units to the data and be able to calculate.

Select the area where you want to enter data, bring up the RG general format in the [Custom] window of the cell formatting window, type the element directly, and click [OK]. When entering data, the number will be automatically brought with you after typing the number, and it will not affect the calculation!

7.De-duplicate.

Ctrl+A] Select all data, click [Data] Banquet Potato Item Card - [Column] - [Delete Duplicate Value], and the duplicate data will be deleted at one time!

8.Lightspeed screening.

To filter out all the member information of [Douyin Department], you only need to find a [Douyin Department], right-click the mouse - [Filter] - [Filter by cell value], and all the data of [Douyin Department] will be filtered out.

9.The serial number is updated automatically.

To do **column number, enter 1 and then enter 2 to pull down, in case you delete a line of serial number, it will be all messed up! We can enter [=row ()1] in the second line of the [Serial number] column, press [Enter], and just fill it in!

10.Mobile phone numbers are displayed in segments.

No need to manually type short dashes! First, select the area to be entered data [Ctrl+1] to quickly call it out, set the format of the single splitter grid, window, and change the RG general format to 000-0000-0000 in [Custom].

This one is going to use **. 12=3*4 doesn't take into account losses?

Choose a for this question.

Find and Replace can both find and replace content and formatting!!

1. In excel, the date is actually stored as a number, that is to say, 1 represents January 1, 1900 2 represents January 2, 1900, and so on. You make all the date types numeric and you get it, and you'll see that they're all numbers.

2. Some explanations of the max function, here are the instructions.

A parameter can be a number or a name, array, or reference that contains numbers.

Logical values and text representing numbers typed directly into the parameter list are counted.

If the parameter is an array or reference, only the numbers in that array or reference are used. Blank cells, logical values, or text in arrays or references are ignored.

If the parameter does not contain a number, the function max returns 0 (zero).

An error will occur if the parameter is an error value or if it is text that cannot be converted to a number.

If you want the calculation to include logical values in references and text that represent numbers, use the maxa function.

1. Obviously, that cell is date-type, when you enter 1, it will be converted into a date representation, that is, 1900 1 1, just like if you enter 1 in any cell, and then format this cell as a date-type, the result is the same.

2. True and false will be treated as 1 and 0 in Excel, that is, if you enter max(0,-1,true) is actually equivalent to max(0,-1,1), the result is of course 1, you can enter for example =--true will also get 1

1. The original cell is in date format, after deleting the data, enter the numbers, and Excel retains the original date format. 1 is the number of sequences for January 1, 1900, and 1 is displayed as a date for January 1, 1900.

2. =max(0,-1,true), true is equivalent to 1, and in some functions, true and 1 can be used equally (false is equivalent to 0).

1.You know that cell is a date type, and setting it to regular is 1.

2.true=1, 1 is definitely the maximum.

That's because of the cell formatting! Because you entered the date before! Then you enter a number in this cell, and it defaults to the date format.