EXCEL expert advice! Urgent
[Users questions | Browse:47 | Favorites]
Users questions: A John Doe Joe Smith 2B 3C 2 ........ king five more than ten thousand lines of existing content such as these. According to the figures given in the third column in the insert blank lines between two lines, namely the A line and B line inserted between the line 2, line B and C lines inserted between the three lines. Please give a detailed answer at the same time try to explain , Will use the BVA?
Experts answer: Instructions: 1, data is inserted before the original serial number column, enter 1 in A2 in A3 enter "= A2 + D2 +1", copy down the need to place such as A31. As listed in column A as shown in red. 2, enter 1 in the F2, the sequence down to fill the F99, such as Column F is shown in blue. 3, G2, H2, respectively, enter the formula "= IF (ISERROR (VLOOKUP (F2, A: C, 2 ,)),"", VLOOKUP (F2, A: C, 2 ,))","= IF (ISERROR (VLOOKUP (F 2, A: C, 3 ,)),"", VLOOKUP (F2, A: C, 3 ,))", then select G2: H2, copied down to 99 firms, the results as shown in the green zone. 4, copy G2: H99, "Paste Special * value * OK" to eliminate the formula 5, and finally, A: F column deleted to complete the meaning of the questions asked for. Accessories: Inserts the specified number of blank lines. Xls
Experts answer: Instructions: 1, data is inserted before the original serial number column, enter 1 in A2 in A3 enter "= A2 + D2 +1", copy down the need to place such as A31. As listed in column A as shown in red. 2, enter 1 in the F2, the sequence down to fill the F99, such as Column F is shown in blue. 3, G2, H2, respectively, enter the formula "= IF (ISERROR (VLOOKUP (F2, A: C, 2 ,)),"", VLOOKUP (F2, A: C, 2 ,))","= IF (ISERROR (VLOOKUP (F 2, A: C, 3 ,)),"", VLOOKUP (F2, A: C, 3 ,))", then select G2: H2, copied down to 99 firms, the results as shown in the green zone. 4, copy G2: H99, "Paste Special * value * OK" to eliminate the formula 5, and finally, A: F column deleted to complete the meaning of the questions asked for. Accessories: Inserts the specified number of blank lines. Xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.