I have over ten thousand rows of data I'm comparing. The first two columns are ten-digit codes, and after that is a bunch of extra information. The ten-digit codes are organized in such a way that 0101 is the first category, 0102 is the second category, all the way to 9998. If you break these four digits down further, you see that the format is as such: XXYY, where XX is the master category and YY is the sub-category. There are many gapsfor example, the first category/sub-category is 0101 but it stops at 0106, then goes to the next master category, 02, whose range is 0201 to 0210.
I need to break down my list of over ten thousand items by category and sub-category, and I thought conditional formatting would be a good way to do that. Is there a way, in Excel 2011 or Numbers '09, that I can color the cells based on the first four digits they have (or by the whole ten-digit number, for example: 0101000000 to 0101999999), without needing to manually create a new rule for each group of four numbers? That would be over a hundred rules. And once I do that, are there functions that can analyze data within those groups? Thanks for any suggestions!
I need to break down my list of over ten thousand items by category and sub-category, and I thought conditional formatting would be a good way to do that. Is there a way, in Excel 2011 or Numbers '09, that I can color the cells based on the first four digits they have (or by the whole ten-digit number, for example: 0101000000 to 0101999999), without needing to manually create a new rule for each group of four numbers? That would be over a hundred rules. And once I do that, are there functions that can analyze data within those groups? Thanks for any suggestions!
