Good afternoon, I was wondering if someone can help me out real quick. I want to build an average based on the length of ranges that contain "1". For example:
Column A: 1 1 1 1 0 0 1 1 0 1 1 1
There are 3 continous ranges with 1. The sum of each range is 4, 2 and 3 means that the average lenghts of the ranges is 9/3 = 3. Is there a formula or vba code to return the results for each column? The data range is from A1:AZL522
Many Thanks for your help!
All the best, Max
Aucun commentaire:
Enregistrer un commentaire