Counting Consecutive Periods In Rows Using Numbers

Yaaseen23 · #1 03-18-2017, 01:30 AM

Hi All

If anyone can help, it would be much appreciated, I have attached a picture.
I look at large datasets to pick up trends on when devices are not working & will indicate how long it takes to get resolved.
i need a formula to pick up if a device was below 90% uptime, consecutively,2 days in a row. the same formula will be used for 2,3,4& 5 days consecutively.
i highlighted the cells with conditional formatting to visually indicate, although i need the figures.

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