Forum Discussion
Performing count and max commands on multiple groups of rows
Let's say you have rows:
0.000 0.000 0.000 5.000 6.000 10.000 0.000 0.000 0.000 5.000 ...
There is no consistency between the sets, just groups of zeros and non-zeros.
I need a se...
Hi,
Let your data starts from first cell.
In Cell B3, Put "=COUNT(A1:A3)"
In Cell B6, Put "=COUNT(A4:A6)"
In Cell C6, Put "=MAX(A4:A6)"
By coping and pasting these formula, you can get result.
But count of rows should be multiple of 6, or else you can't paste for entire cell for getting result.