Create an Advanced Filter.
Click the Criteria sheet tab.
Type >12/31/18 in cell A3 to find records after 2018.
Type mri in cell B3.
Type >12/31/19 in cell A4, to find records after 2019.
Type ct scan in cell B4. This criteria will find records dated 2019 or later for MRIs and records for CT scans dated 2020 or later (Figure 4-94).Figure 4-94 Criteria for Advanced Filter
Click cell A5 on the Adv Filter sheet.
Click the Advanced button [Data tab, Sort & Filter group].
Select the Copy to another location radio button.
Verify that the List range is cells $A$4:$E$60. If the range is incorrect, click and drag to select the range including the header row.
Click the Criteria range box and select cells A2:B4 on the Criteria sheet.
Click the Copy to box and select cells G4:K4 on the Adv Filter sheet.
Click OK in the Advanced Filter dialog box.