In practical work, what problems should Excel pay attention to in important or frequent operations a

So be it: d2 input.

if(row() array formula, do not press enter after entering, press ctrl+shift+enter to end the calculation, and then fill it down.

To give you a test, column A and B each have 10 rows of data, of which column A has 6 rows of data that are the same as column B, the corresponding data will be returned, and the remaining 4 rows will be placed at the bottom of column B if there is no same data

Insert a blank column between column A and column B (right-click on column B, "Insert"), and then use the formula for B2 in the second row of this blank column

iferror(vlookup(c2,a:a,1,),dropdown.

Enter or copy and paste the following formula in D2.

iferror(vlookup(a2,b:c,2,),0)

Pull-down padding. Select the C:D columns, hidden.

The problem description is incorrect. As mentioned earlier, column B is not moving, and it is requested that column B be placed in AColumn peers, contradictory, please re-review. Then ask questions.

3.Fill cells quickly.

4.How do I find and replace content in Excel?

In Excel, we often need to know that we want to copy cells. You can select the cells you want to copy, then select the cells you want to paste, and use Ctrl+V to paste. Lack of fibrillation.

5.Quickly delete cell contents.

Subtract 8 hours and not only the date may change, but also the month and year may change. Here's how to deal with it:

1) Combine your month, day, and year into time.

2) The time - 8 hours to draw a new time.

3) Resplit the time into year, month, day, and hour.

Here's how:

Suppose the year is column A, the month is column B, the day is column C, the start time is column D, and the end time is column E (note that these cells are not left blank).

1) Combine for time.

If you set the start time of the f column (format to time), set the time of the g column to the corresponding line number (format set to time), then set the corresponding line number 2) to rewind 8 hours each.

Set the H column to 8 hours backward from the start time (set to time), Hi=Fi-8 to set the time for the i column to go back 8 hours (set to time), and ii=gi-83).

Let j, k, l, and m be the year, month, day, and hour of the time 8 hours after the start and regression, respectively, and have ji=year(hi).

ki=month(hi)

li=day(hi)

mi=hour(hi)

Let o, p, q, and r be the year, month, day, and hour of the time 8 hours after the start and time are reversed, respectively, and oi=year(ii).

pi=month(ii)

qi=day(ii)

ri=hour(ii)

1. Fill up the months.

2. Auxiliary column e, e2=day(2010,a2,b2).

3. Auxiliary columns.

4, auxiliary column g, g2=d2 24

5. Auxiliary column h, you need to get the start date (-8), h2=if(f2-8 24<0,e2-1,e2).

6 Auxiliary column i, you need to get the start time (-8), i2=if(f2-8 24<0, f2+1-8 24, f2-8 24).

7,j2=if(g2-8/24<0,e2-1,e2)

8,k2=if(g2-8/24<0,g2+1-8/24,f2-8/24)

where f, g, i, and k are set to the time format. h,j is the date format. All drop-downs.

Easier way:

2. Auxiliary column e, e2=day(2010,a2,b2).

3. Auxiliary columns, set to time format.

4, auxiliary column g, g2=d2 24, set to time format.

h,h2=text(e2+f2,"y-m-d hh:mm:ss")-8/24

i,i2=text(e2+g2,"y-m-d hh:mm:ss")-8/24

h,i is the result that lz wants. Drop down.

Let's say you start with four columns of ABCD, and the new result is four columns of FGHJ.

Then day g = b - if((c-8)<0,1,0).

It's not that difficult to be in the same column, but it's much more difficult to divide into several columns.

Send the problem as an attachment to the content and sample table (please note: if you want to be in the 03 version, the current situation and target effect will be displayed).

Is there a selection to locate the visible cells first (especially by pressing alt+; shortcut), and then copy and paste is to paste only the visible cells, otherwise it is full sticky.

Enter or copy and paste the following formula in A1.

indirect("m1")

Enter the formula in cell b1:

indirect(a1)

How about trying?