Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Unique Empty Cells of a Range
Hello all, I have a question regarding the count functions with excel. I am wondering how to count sets of "unique" empty cells within a range? Take the example below: [image: http://doggpoundclan.com/images/excelexample01.jpg] Within a row, I would like a count of how many instances of "2 empty cells in a row", and how many instances of "3 empty cells in a row", and how many instances of "4 empty cells in a row", etc, etc. So in the first row, there are 2 instances of "2 empty cells in a row", 1 instance of "3 empty cells in a row", and 1 instance of "5 empty cells in a row". The second row has 3 instances of "2 empty cells in a row", and 2 instances of "3 empty cells in a row". How would I go about counting all the sets of empty cells and defining them in a table? -- IronDogg ------------------------------------------------------------------------ IronDogg's Profile: http://www.excelforum.com/member.php...o&userid=33291 View this thread: http://www.excelforum.com/showthread...hreadid=531171 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique text/number cells from a range | Excel Discussion (Misc queries) | |||
Counting unique text/number cells from a range | Excel Programming | |||
Counting unique text/number cells from a range | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |