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
