Below, I have pasted a screenshot of the workbook that I have created in Excel. It contains things that have occured in the past 24 hours, all within five minute increments. I would like a code that would search through every row labeled DIRs and find cells that contain strings. Then, search the Alerts row and find any strings that occured 36 hours before the given DIR? It would basically correlate any alerts that happened within 36 hours of a DIR. I know that is a lot to ask, but anything that you could come up with would be very helpful. Thank you!
<colgroup><col style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;" width="123"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" span="3" width="77"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" width="95"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="6" width="76"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="9" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="2" width="76"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" width="84"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" width="84"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" span="2" width="77"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <tbody>
</tbody>
15-Oct | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Time | 0:00 | 0:05 | 0:10 | 0:15 | 0:20 | 0:25 | 0:30 | 0:35 | 0:40 | 0:45 | 0:50 | 0:55 | 1:00 | 1:05 | 1:10 | 1:15 | 1:20 | 1:25 | 1:30 | 1:35 | 1:40 | 1:45 | 1:50 | 1:55 | 2:00 | 2:05 | 2:10 | 2:15 | 2:20 | 2:25 | 2:30 | 2:35 | 2:40 | 2:45 | 2:50 | 2:55 | 3:00 | 3:05 | 3:10 | 3:15 | 3:20 | 3:25 | 3:30 | 3:35 | 3:40 | 3:45 | 3:50 | 3:55 | 4:00 | 4:05 | 4:10 | 4:15 | 4:20 | 4:25 | 4:30 | 4:35 | 4:40 | 4:45 | 4:50 | 4:55 | 5:00 | 5:05 | 5:10 | 5:15 |
Alerts | Guard Availibility Level I, Target Type 0-2 Range Level II | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DIRs | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Maint. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
16-Oct | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Time | 0:00 | 0:05 | 0:10 | 0:15 | 0:20 | 0:25 | 0:30 | 0:35 | 0:40 | 0:45 | 0:50 | 0:55 | 1:00 | 1:05 | 1:10 | 1:15 | 1:20 | 1:25 | 1:30 | 1:35 | 1:40 | 1:45 | 1:50 | 1:55 | 2:00 | 2:05 | 2:10 | 2:15 | 2:20 | 2:25 | 2:30 | 2:35 | 2:40 | 2:45 | 2:50 | 2:55 | 3:00 | 3:05 | 3:10 | 3:15 | 3:20 | 3:25 | 3:30 | 3:35 | 3:40 | 3:45 | 3:50 | 3:55 | 4:00 | 4:05 | 4:10 | 4:15 | 4:20 | 4:25 | 4:30 | 4:35 | 4:40 | 4:45 | 4:50 | 4:55 | 5:00 | 5:05 | 5:10 | 5:15 |
Alerts | PTU- Warm up Oscillator current error, Azimuth Accuracy Level II, Elevation Accuracy Level II | PHM to RAMS Interface Failure, RCSP to PHM Interface Failure, 5 Axis - (+X/+Y) CBIT Error, 5 Axis - (-X/+Y) CBIT Error, 5 Axis - (+X/-Y) CBIT Error, 5 Axis - (-X/-Y) CBIT Error, 5 Axis - Azimuth Actuator CBIT Error, 1 Axis - Elevation CBIT Error, RCSP Ethernet 2 Interface Failure, Single Axis - Elevation Fault, Five Axis - Rotation Fault | PHM to RAMS Interface Failure, RCSP to PHM Interface Failure, PTU - Warm up Oscillator current error, 5 Axis - (+X/+Y) CBIT Error, 5 Axis - (-X/+Y) CBIT Error, 5 Axis - (+X/-Y) CBIT Error, 5 Axis - (-X/-Y) CBIT Error, 5 Axis - Azimuth Actuator CBIT Error, 1 Axis - Elevation CBIT Error, RCSP Ethernet 2 Interface Failure, Azimuth Accuracy Level II, Elevation Accuracy Level II, Single Axis - Elevation Fault, Five Axis - Rotation Fault | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DIRs | System fell to Standby | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Maint. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
17-Oct | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Time | 0:00 | 0:05 | 0:10 | 0:15 | 0:20 | 0:25 | 0:30 | 0:35 | 0:40 | 0:45 | 0:50 | 0:55 | 1:00 | 1:05 | 1:10 | 1:15 | 1:20 | 1:25 | 1:30 | 1:35 | 1:40 | 1:45 | 1:50 | 1:55 | 2:00 | 2:05 | 2:10 | 2:15 | 2:20 | 2:25 | 2:30 | 2:35 | 2:40 | 2:45 | 2:50 | 2:55 | 3:00 | 3:05 | 3:10 | 3:15 | 3:20 | 3:25 | 3:30 | 3:35 | 3:40 | 3:45 | 3:50 | 3:55 | 4:00 | 4:05 | 4:10 | 4:15 | 4:20 | 4:25 | 4:30 | 4:35 | 4:40 | 4:45 | 4:50 | 4:55 | 5:00 | 5:05 | 5:10 | 5:15 |
Alerts | Guard Availability Level I, Azimuth Accuracy Level II, Elevation Accuracy Level II, Target Type 0-2 Range Level II | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DIRs | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Maint. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;" width="123"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" span="3" width="77"> <col style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" width="95"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;" width="85"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="6" width="76"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2889;" width="79"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;" width="83"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="9" width="76"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 65pt; mso-width-source: userset; mso-width-alt: 3145;" width="86"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="2" width="76"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" width="84"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" width="77"> <col style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" width="84"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;" span="2" width="77"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" width="80"> <tbody>
</tbody>