Urgent! EXCEL2000 can t be used!

I wish you a speedy solution to the problem.

See if Excel2000 is in conflict with your newly installed software!

Simple. Suppose the column in which the locker cell is located (the name column) is in column B and the quantity is in column C, as if:

a b c name quantity.

Locker 8 computers 1

Desk 2 I. Add the formula to the column before the name column. In this example, in column A, add "1" to cell A2 before the first name, and add "=A2+C2" to cell A3, and copy the formula of cell A3 down until it exceeds column B (name column). If the last "desk" is in cell B4, then the formula in column A is copied to cell A5.

2. Add "1" to cell E2, "2" to cell E3, and "3" to cell E4......That is, column e is sequentially filled down until it is equal to or greater than the sum of the quantities, which is greater than or equal to the maximum value of column a.

3. Add the formula "=vlookup(e2,$a$2:$b$5,2)" to cell F2 and copy it downward. where "$a $2:

"b$5" refers to the range of cells with data in columns A and B. The formula can also be "=vlookup(e2,$a:$b,2)".

Copy all the way to the same as the maximum serial number in column E.

ok!That's it!

It is displayed as: a b c d e f g

Serial Number Name Quantity Serial Number Name.

1 Locker 8 1 Locker.

9 computers 1 2 lockers.

10 Desks 2 3 Lockers.

12 4 Lockers.

To be on the safe side, make one copy first, select all, click the Merge Cells button on the toolbar once, and then fill in the split cell data according to the data before splitting.

1. Ideas:

You can add a column to list the statistical results, the same display is 1, the different display is 0, and then the sum of the columns is the same number.

2. Operation: Auxiliary column input: =if(and(a3=sheet2!a3,sheet2!b3=sheet1!b3), 1,0), i.e., a3 = a3 in Table 2, and b3 in Table 2 = b3 in Table 1, 1 is returned, otherwise, 0 is returned

3. Screenshot.