| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count filled cells in range if they are one after the other
Hello to all!!
I have one question if anybody can help me, in range I have to calculate how many filled cell is they are one ater the oher. Example: A AE 3 3 1 1 2 2 3 3 1 1 1 1 1 1 1 2 2 2 2 2 2 Result if possible: 2filled 6filled 7filled 6filled If somebody understand what I meen don't fear to help. Thanks Best regards Ivo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a count of number of cells filled in? | Excel Discussion (Misc queries) | |||
| Count filled colour in cell in given range | Excel Discussion (Misc queries) | |||
| I need formula that will automatically count the filled cells. | Excel Discussion (Misc queries) | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
| Count Rang of Filled-In Cells | Excel Worksheet Functions | |||
Threaded Mode
