count contiguous non-zero blocks?

M

Marji

Is it possible to design a function or devise a macro in
Excel to count the number of unique blocks of cells that
are contiguous and contain non-zero values? This would
be calculated for each row seperately assessing the
contiguity of the non-zero values moving across the
columns.

Thanks in advance for any ideas.

Cheers :)
Marji
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Minimum nonzero value for non-adjacent columns 9
using slope function with non contiguous cells 1
Looping through Non contiguous cells in a row 11
Counting Zeros in a row until encounter first non-zero value 9
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
COUNTIF with a non contiguous range 1
Counting assistance 3

Top