EXCEL choose to remove a problem
[Users questions | Browse:102 | Favorites]
Users questions: I was doing the company's sales breakdown, because of too much data, I just keep summary data, and should detail removed, but my company has thousands of products too much, I'm afraid vertigo delete the wrong, will how can I change the quick and easy to do. Annex
Experts answer: Instructions: 1. In E2 enter the formula "= IF (CODE (A2) 65, D2 ,"")", copy down to E11, the results as following the yellow area on the table. 2, copy the yellow zone, "Paste Special * value * OK" to remove the formula. 3, the original amount of column D1: D11 deletion. 4, for Illustrate the process, not the implementation of the above steps 2 and 3, to add operating above steps 2 and 3, the results as following table. Attachment: remove unwanted content. Xls
Experts answer: Instructions: 1. In E2 enter the formula "= IF (CODE (A2) 65, D2 ,"")", copy down to E11, the results as following the yellow area on the table. 2, copy the yellow zone, "Paste Special * value * OK" to remove the formula. 3, the original amount of column D1: D11 deletion. 4, for Illustrate the process, not the implementation of the above steps 2 and 3, to add operating above steps 2 and 3, the results as following table. Attachment: remove unwanted content. 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.