Forum Discussion
counting an the number of cells in which a run on 1s appears
I am creating a spread sheet for a stats class. I am simulating tossing a fair coin and having 1 appear if it is a head and 0 if it is a tail. I'd like to calculate the longest run of 1s in each row, where a row represents 100 tosses of a coin. Thanks.
3 Replies
For such sample
formula could be
=MAX(FREQUENCY( IF(A1:J1=1,COLUMN(A1:J1)),IF(A1:J1=0,COLUMN(A1:J1))))That's array formula entered by Ctrl+Shift+Enter
- Thanks Sergie. It is not quite working. I changed the As to Bs because my data starts in column B. Otherwise I just did a cut and paste. I get #Value! as error message. When I try to trace it I just get a line across row 1. Any thoughts?
It works in next row as well. Do you use the formula as array one, with Ctrl+Shift+Enter?
If you attache sample file it'll be easier to find the source of the issue.
