Thread: Calculate recurring instances between cell count - using trigger - URGENT HELP
View Single Post
 
Old 07-07-2018, 07:59 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In the attached see columns H:I.
It goes wrong when it finds 4 (or more) in a row, it thinks they're two triplets next to each other.
The max is 40, there's only one, lying between triplet at row 6612 above, and triplet at row 6857 below.



Any use?
Attached Files
File Type: xlsx msofficeforums39538Cell count.xlsx (485.3 KB, 9 views)
Reply With Quote