I would like to thank you for the manpower and personnel information and statistical tables of the f

The vlookup and sumif functions are done. There are three tables of incoming, general ledger and outgoing. Columns are added to the summary table for classification, and various summary tables can be obtained by using pivot tables.

Let's modify it yourself and use it.

The way you supplement is not recommended for you to use it this way! In particular, you say that an item and a table are ...... such practicesHow big do you have to use to show your ** A wrench has n specifications! A bolt also has n more than one specification!

And if none of these options are for you, you need to point out what you think needs to be improved to fit your habits! What you are given is the ...... of the plan that everyone usually takesYour list below is not suitable for statistical purposes......It is a feasible ...... as a categorical display

It's actually quite easy, but it's trivial. Can I add more points?

If you want to cross worksheets, you can use the indirect function, and if you want to cross worksheets, you need to use VBA.

**VBA is fine. Formulas should not be filterable.

Sent.

How to use: 1. This table can only count the room rate of the current month.

2. Add the room number in ** (note: the statistical table and the water, electricity, hot water and other work tables must be in the same row with the same room number), and copy the formula downward.

3. Fill in the number of meter readings in the water, electricity, hot water and other work sheets.

The electronic file has been sent to your mailbox, and there is a formula in the table, and you can directly enter the data to find the monthly fee for each room number;

For this problem, if there is a name in Table 2, then you can use the vlookup function.

In Table 2, enter the formula for C1 = vlookup(a1, select all regions in Table 1, 3,0), and then drop down the data.

There are no row and column markers in the figure, and no specific formula can be written.

You write the column mark, in fact, it is very simple, in the cell without a ticket, enter the equal sign.

Then click on the unit under Amount.

Write the minus sign and click on the unit enter under the ticket.

If the amount cell is A1, the votes are B1, the votes are C1, and the remarks are D1

Enter the formula "=A2-B2" in the C2 unit", and then put the light ticket in the lower right corner of cell C2, drag the formula down, and it's OK,

In the No Ticket field, enter = Click on the amount of the block - Click on the ticket block to confirm.

Elaborate on the requirements, and it's a good idea to make a document. The specific details are communicated in detail.

Permutations and Combinations function.

That's not going to work.

If you don't program, you can do it artificially.

For example, the permutation and combination of two columns ab.

A4 number, B3 number.

That's in the m column to get a 3 1 3 2... A total of 12 numbers, n columns, copy the numbers in column b, select 12 grids and paste, (if you need to remove the repetition, remove it) if you want to arrange it with c, repeat the steps.

Haha tired you.