Hi and good evening,how would I perform a lookup on 1 unique "date time value" in columns D and F and return their matches from columns C or E all sorted from oldest to newest (like finished Data Set below).Times and Dates in columns D and F are formatted as "ddd-dd-mmm-yy hh:mm".Also I would like to ask is it possible to use the SMALL formula on multiple sheet ranges in a workbook.
Thanking You In Advance.
Data Set
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Finished Data Set
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
Thanking You In Advance.
Data Set
Machine ID | Size | Batch (1) | Machine Stop (1) | Batch (2) | Machine Stop (1) |
1 | Small | ABC-1014 | Tue-09-Jul-19 20:35 | ABC-1020 | Mon-08-Jul-19 17:13 |
2 | Medium | ABC-1115 | Mon-08-Jul-19 15:54 | ABC-1081 | Mon-08-Jul-19 19:30 |
3 | Large | ABC-1016 | Mon-08-Jul-19 11:13 | ABC-1142 | Wed-10-Jul-19 00:11 |
1 | Medium | ABC-1017 | Wed-10-Jul-19 01:16 | ABC-1203 | Wed-10-Jul-19 09:52 |
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
Finished Data Set
Machine ID | Size | Batch # | Machine Stop |
3 | Large | Mon-08-Jul-19 11:13 | ABC-1016 |
2 | Medium | Mon-08-Jul-19 15:54 | ABC-1115 |
1 | Small | Mon-08-Jul-19 17:13 | ABC-1020 |
2 | Medium | Mon-08-Jul-19 19:30 | ABC-1081 |
1 | Small | Tue-09-Jul-19 20:35 | ABC-1014 |
3 | Large | Wed-10-Jul-19 00:11 | ABC-1142 |
1 | Medium | Wed-10-Jul-19 01:16 | ABC-1017 |
1 | Medium | Wed-10-Jul-19 09:52 | ABC-1203 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>