Step $1$: Cleanse data for.. $($save this data on the right for later inspection and$/$or correciton $)$

a$.$ Invalid Invoice # $($must start with A followed by $7$ digits$)$

b$.$ Invalid Part # $($only the $4$ listed in Reference Table are valid$)$

c$.$ Other invalid data $($e$.$g$.$ text in numerical fields, dates out of range$)$

Step $2$: Compute the Days Late $($positive values$)$ or Days early $($negative values$)$

Step $3$: Remove outliers $($save data for individual analysis of cause$)$

Step $4$: Insert the Item name of each order $($use the VLOOKUP function for "exact match"$)$

Step $5$: Filter data by Part # showing only data for $"12-23451"$

Step $6$: Sort displayed data by "Days Late" $($highest to lowest$)$