Amit Punia
Member
Need a formula or VBA Code which will check the 3 criteria on Site ID, Observation and if there are 6 consecutive continuous dates.
Data sheet is to be used to get the output.
For e.g.
Criteria 1  Checks if Site ID is A1000.
Criteria 2  Checks if Observation is "AC is not working".
Criteria 3  If there are 6 consecutive continuous dates in Date of Observations.
If all the three criteria matches then it should show the Start Date and End Date.
In the Output Sheet, Site ID and Observations are already mentioned. Need the formula or VBA Code for Start Date and End Date.
Output Cells where Formula or VBA Code is required are colored in yellow in the Output Sheet.
Thanks in Advance
Data sheet is to be used to get the output.
For e.g.
Criteria 1  Checks if Site ID is A1000.
Criteria 2  Checks if Observation is "AC is not working".
Criteria 3  If there are 6 consecutive continuous dates in Date of Observations.
If all the three criteria matches then it should show the Start Date and End Date.
In the Output Sheet, Site ID and Observations are already mentioned. Need the formula or VBA Code for Start Date and End Date.
Output Cells where Formula or VBA Code is required are colored in yellow in the Output Sheet.
Thanks in Advance
Attachments

14.3 KB Views: 7