Counting Consecutive Periods In Rows Using Numbers

Yaaseen23 · #1 03-22-2017, 01:54 PM

rows actually:

N2 to N11

O2 to O11
P2 to P11

xor · #2 03-22-2017, 08:18 PM

Thank you, but I still don't understand.

Please take a look at the attached and give complete details as to how you come to 3, 2 and 1 in N2:P2.

I see one instance of 3 consecutive days under 90% and 1 instance of 4 consecutive days under 90%.

Yaaseen23 · #3 03-23-2017, 02:22 PM

Quote:

Originally Posted by xor

Thank you, but I still don't understand.

Please take a look at the attached and give complete details as to how you come to 3, 2 and 1 in N2:P2.

I see one instance of 3 consecutive days under 90% and 1 instance of 4 consecutive days under 90%.

OK here we go.

Consecutive 2days in a row=count of 3
How... B2+c2=1;i2+j2=1;k2+l2=1, thus giving the answer 3

Consecutive 3days in a row =count of 2
How...B2+c2+d2=1;i2+j2+k2=1, thus giving the answer 2

Consecutive 4days in a row=count of 1
How...I2+j2+k2+l2=1, thus giving the answer 1.

Hope that helps. Sorry for late reply. Worked late.

Regards

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting rows with a macro?	Jennifer Murphy	Word Tables	1	08-23-2016 03:00 PM
Counting table rows in a page	RavenSuzumiya	Word Tables	1	06-09-2016 03:38 PM
VBA merging cells and counting Merged rows	Snaybot	Excel Programming	2	11-09-2015 03:56 AM
find and replace consecutive numbers	kpl_39	Word	1	06-07-2013 05:04 AM
Consecutive page numbers on multiple documents	georgeeasten	Word	1	02-10-2011 02:12 AM