I m asking a question about Excel with all my credits, and I m going to ask someone to rescue 20

You can solve it with the Excel insertion function vlookup. The specific method is to insert the function fx in the column where the number to be taken in table A -- select the category:

All parts -- select the function: vlookup, OK -- click the contract contract number of table A in the first column -- click the entire worksheet of the table in the second column -- fill in the column of column B in the third column the number of columns to be taken in table B -- fill in the last column false OK.

If it refers to the double line above, it is to change the bottom line of the upper row to a double bottom line box, which is in the border drop-down menu.

If it means that two vertical rows are crossed, you can use cell merging to achieve it.

If it refers to the empty line below, it is a hollow line, and the vertical ** line in the middle is not drawn.

<> the width of the two columns of e and f could be smaller, but I have set a larger one to make it easier for you to see it.

In fact, it tells you that these are achieved by merging or not merging cells.

Merging cells does just that. Very simple.

Assuming the data is in column A, enter it in B1.

if(and(isnumber(find(0,a1)),isnumber(find(1,a1)),isnumber(find(9,a1)))1,"")

B1 formula drop-down:

if(count(find(,a1))=3,1,"")

The title says (can output any number), if you find 019 but not a fixed output of 1, use the following formula, 100 in the formula is a random input of 1-100 number range, if it is 1-1000, change 100 to 1000 on the line.

if(count(find(,a1))=3,int(rand()*100+1),"")

If the values you are looking for are often changing, you can put these values in a free cell, in this case choose to put it in d1, and then the formula reference will do.

if(count(find(mid(d$1,,1),a1))=3,1,"")

If even the value of d1 is not fixed to find three digits, such as sometimes looking for two digits, sometimes looking for five digits, with this array formula, do not enter directly after the input is completed, press the three keys Ctrl+Shift+Enter to end.

What I didn't say about reinstalling Microsoft Office may be corrupted, and there is a conflict between your computer system and Microsoft Office. Install the older version and take a look.

Right-click in the chart area, select Change Chart Type from the pop-up right-click menu, and select Percentage in the secondary axes.

Right-click on the large white area in the chart, select "Source Data", and change the data region in "Series".

If the data range is not selected, select the corresponding curve on the table to delete.

Friend, do you want to **excel installer, or just ask questions just to not ** courseware? Please see my question, give the question additional thanks, don't ask the question that causes 2 meanings, thank you!

I can't understand your question, how can I help you?

I have sent an email, but I use software, but the software is free, suitable for the management of purchase, sale and inventory, called: Wisdom - Kingdee friends of the free purchase, sale and inventory, the operation is simple, input data can be automatically counted, very practical. Install it online** and it will be ready to use

Different businesses, the content of the table will be different, I can make a management suitable for your use according to your business**. If you are interested in knowing, please hi or q me, click on my username to see my information, or go to my space to see some ** function demonstrations.

What do you want to ask? Function or VBA? Or is it formatting?

You can go to the next software and export it to Excel.

I think I'm stupid enough to do that.

Our unit uses raw treasures.

Every month, the accountant blindly sends the good account guide grinding into excel**.

Super convenient.