Microsoft Office Forums - View Single Post - Counting Consecutive Periods In Rows Using Numbers

Thread: Counting Consecutive Periods In Rows Using Numbers

View Single Post

Old

03-22-2017, 08:18 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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%.

Attached Files

Consecutive.Days.xlsx (71.5 KB, 17 views)

Reply With Quote