worldCurrencies
New Member
- Joined
- Mar 7, 2022
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
I want to find the average of something occurring consecutively. For example, in Column A, I would have the array: {1,1,1,0,0,0,1,1,1,1,0,0,1,0}. I want to find that 1 occurred consecutively 3 times, and every time it occurred consecutively, it averaged to be consecutive for 2.6. I found this from (3+4+1) / 3.
How would I find this in excel?
How would I find this in excel?