Nested If formula?
One of my colleagues needs to flag each record that has 3 or more consecutive days with a 1 in a column. Attached simple spreadsheet demonstrates what he's trying to get.
Tricky.xlsx
Tricky.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER