This is a complex ask, so I apologize if it's unclear and will be happy to clarify. I have a series of numbers (dice rolls, in this case), and I need a formula to do the following:
- Find groups of consecutive SAME numbers (i.e. two or more 1's in a row)
- identify the largest of those groups
- count how many occurrences of that number are in the largest group
And just to clarify, I don't need all three of those as output - I just need #3 as a number.
I've made a copy of the sheet here: https://docs.google.com/spreadsheets/d/1CS9gxUvRAgFFyKjsyrQHgXDZKaUyYvzC16sCZED1a7Y
Any help with this would be greatly appreciated!