Oct 02 2019 08:58 AM
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.
Oct 02 2019 10:35 AM
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
Oct 02 2019 12:09 PM
Oct 02 2019 01:45 PM
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.