excel how to filter and distinguish between the number of consecutive
[Users questions | Browse:234 | Favorites]
Users questions: For example, a No. 1-10000, which is continuous 1-25, 26, 27 - 55 is not continuous 51-200 not ,201 - 399 is continuous, so! Number of missing is not the law!
Experts answer: Instructions: First, the Advanced Filter screen out: 1, selected A1: A254. 2, "data * Advanced Filter * Filter * Filter the results will be copied to another location * Conditions zone * D1: E2 * copy * D5 * OK", the results of D5: D30. 3, according to the same 1,2 methods, the G5: G34, J5: J204. For reference. Two , Conditional formatting, marked: 1, select A2: A254. 2, "format, conditional formatting * conditions * 1 * formula *= $ A2 = $ A1 +1 * format * pattern * color * pink * font color * white * * OK. " 3, no fill color of each cell with the following continuous pink cell, which Form a continuous data area; fill the cells with no marked boundaries of the two regions. For reference. Appendix: Advanced Filter 01.xls
Experts answer: Instructions: First, the Advanced Filter screen out: 1, selected A1: A254. 2, "data * Advanced Filter * Filter * Filter the results will be copied to another location * Conditions zone * D1: E2 * copy * D5 * OK", the results of D5: D30. 3, according to the same 1,2 methods, the G5: G34, J5: J204. For reference. Two , Conditional formatting, marked: 1, select A2: A254. 2, "format, conditional formatting * conditions * 1 * formula *= $ A2 = $ A1 +1 * format * pattern * color * pink * font color * white * * OK. " 3, no fill color of each cell with the following continuous pink cell, which Form a continuous data area; fill the cells with no marked boundaries of the two regions. For reference. Appendix: Advanced Filter 01.xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- 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
- How does the situation need to find the product selection?
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.