I want to count the highest number of equal cells
thanx alot for your tip.... but I need to be more spesific...... lets say I
got 4 cells in a row with 1 then two cells with 0 then I must start to count
over again....
I only wanna count the larges number of equal cells in a row (1-1-1-1-0-1-0-)
the result will be: number 1= 4
number 0= 1
Hopefully this will explain my problem better.....
"Bob Phillips" wrote:
=FREQUENCY(A1:A13,A1:A13)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"fiur" wrote in message
...
I got a worksheet with only 2 different numbers in each cell like this:
1
1
1
0
0
1
0
0
1
1
1
My question are how do I count the largest number of equal cells...
|