| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count colored rows
I have a large spreadsheet where certain rows are colored red. I would like
to sort on one column, then total the number of red rows in that group as well as obtain a grand total of the number of red lines. How do I accomplish this? Thank you in advance for your help to an Excel novice. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count colored rows
See http://www.xldynamic.com/source/xld.ColourCounter.html
-- HTH RP (remove nothere from the email address if mailing direct) "NoviceLois" wrote in message ... I have a large spreadsheet where certain rows are colored red. I would like to sort on one column, then total the number of red rows in that group as well as obtain a grand total of the number of red lines. How do I accomplish this? Thank you in advance for your help to an Excel novice. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
| Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
| Insert rows | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
