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
[TABLE="class: grid, width: 900"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD="align: center"]Machine ID[/TD]
[TD="align: center"]Size[/TD]
[TD="align: center"]Batch (1)[/TD]
[TD="align: center"]Machine Stop (1)[/TD]
[TD="align: center"]Batch (2)[/TD]
[TD="align: center"]Machine Stop (1)[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]ABC-1014[/TD]
[TD="align: center"]Tue-09-Jul-19 20:35[/TD]
[TD="align: center"]ABC-1020[/TD]
[TD="align: center"]Mon-08-Jul-19 17:13[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]ABC-1115[/TD]
[TD="align: center"]Mon-08-Jul-19 15:54[/TD]
[TD="align: center"]ABC-1081[/TD]
[TD="align: center"]Mon-08-Jul-19 19:30[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Large[/TD]
[TD="align: center"]ABC-1016[/TD]
[TD="align: center"]Mon-08-Jul-19 11:13[/TD]
[TD="align: center"]ABC-1142[/TD]
[TD="align: center"]Wed-10-Jul-19 00:11[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]ABC-1017[/TD]
[TD="align: center"]Wed-10-Jul-19 01:16[/TD]
[TD="align: center"]ABC-1203[/TD]
[TD="align: center"]Wed-10-Jul-19 09:52[/TD]
[/TR]
</tbody>[/TABLE]
Finished Data Set
[TABLE="class: grid, width: 600"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="align: center"]Machine ID[/TD]
[TD="align: center"]Size[/TD]
[TD="align: center"]Batch #[/TD]
[TD="align: center"]Machine Stop[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Large[/TD]
[TD="align: center"]Mon-08-Jul-19 11:13[/TD]
[TD="align: center"]ABC-1016[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Mon-08-Jul-19 15:54[/TD]
[TD="align: center"]ABC-1115[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]Mon-08-Jul-19 17:13[/TD]
[TD="align: center"]ABC-1020[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Mon-08-Jul-19 19:30[/TD]
[TD="align: center"]ABC-1081[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]Tue-09-Jul-19 20:35[/TD]
[TD="align: center"]ABC-1014[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Large[/TD]
[TD="align: center"]Wed-10-Jul-19 00:11[/TD]
[TD="align: center"]ABC-1142[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Wed-10-Jul-19 01:16[/TD]
[TD="align: center"]ABC-1017[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Wed-10-Jul-19 09:52[/TD]
[TD="align: center"]ABC-1203[/TD]
[/TR]
</tbody>[/TABLE]
Thanking You In Advance.
Data Set
[TABLE="class: grid, width: 900"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD="align: center"]Machine ID[/TD]
[TD="align: center"]Size[/TD]
[TD="align: center"]Batch (1)[/TD]
[TD="align: center"]Machine Stop (1)[/TD]
[TD="align: center"]Batch (2)[/TD]
[TD="align: center"]Machine Stop (1)[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]ABC-1014[/TD]
[TD="align: center"]Tue-09-Jul-19 20:35[/TD]
[TD="align: center"]ABC-1020[/TD]
[TD="align: center"]Mon-08-Jul-19 17:13[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]ABC-1115[/TD]
[TD="align: center"]Mon-08-Jul-19 15:54[/TD]
[TD="align: center"]ABC-1081[/TD]
[TD="align: center"]Mon-08-Jul-19 19:30[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Large[/TD]
[TD="align: center"]ABC-1016[/TD]
[TD="align: center"]Mon-08-Jul-19 11:13[/TD]
[TD="align: center"]ABC-1142[/TD]
[TD="align: center"]Wed-10-Jul-19 00:11[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]ABC-1017[/TD]
[TD="align: center"]Wed-10-Jul-19 01:16[/TD]
[TD="align: center"]ABC-1203[/TD]
[TD="align: center"]Wed-10-Jul-19 09:52[/TD]
[/TR]
</tbody>[/TABLE]
Finished Data Set
[TABLE="class: grid, width: 600"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD="align: center"]Machine ID[/TD]
[TD="align: center"]Size[/TD]
[TD="align: center"]Batch #[/TD]
[TD="align: center"]Machine Stop[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Large[/TD]
[TD="align: center"]Mon-08-Jul-19 11:13[/TD]
[TD="align: center"]ABC-1016[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Mon-08-Jul-19 15:54[/TD]
[TD="align: center"]ABC-1115[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]Mon-08-Jul-19 17:13[/TD]
[TD="align: center"]ABC-1020[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Mon-08-Jul-19 19:30[/TD]
[TD="align: center"]ABC-1081[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Small[/TD]
[TD="align: center"]Tue-09-Jul-19 20:35[/TD]
[TD="align: center"]ABC-1014[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Large[/TD]
[TD="align: center"]Wed-10-Jul-19 00:11[/TD]
[TD="align: center"]ABC-1142[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Wed-10-Jul-19 01:16[/TD]
[TD="align: center"]ABC-1017[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Medium[/TD]
[TD="align: center"]Wed-10-Jul-19 09:52[/TD]
[TD="align: center"]ABC-1203[/TD]
[/TR]
</tbody>[/TABLE]