Calculate recurring instances between cell count - using trigger

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Calculate recurring instances between cell count - using trigger - URGENT HELP

FAQ

Thread Tools

Display Modes

07-07-2018, 07:59 AM

p45cal

Windows 10 Calculate recurring instances between cell count - using trigger - URGENT HELP

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

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

msofficeforums39538Cell count.xlsx (485.3 KB, 9 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to trigger a macro on cell selection	Larry_1	Excel Programming	6	12-24-2017 11:09 AM
Cell drop down boxes URGENT	otuatail	Excel	2	02-26-2015 09:51 AM
trying to use vlookup to calculate several different situations in one cell	heastlund	Excel	3	11-21-2013 12:38 PM
Hyperlink in cell to trigger pop up text box	Carpie	Excel Programming	0	08-13-2013 10:33 AM
A recurring word count macro?	bpanda	Word VBA	1	06-11-2013 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:43 AM.