I have been tasked with creating an Excel sheet to rank employees for annual leave pick priority. The issue I am having is trying to meet specific criteria since we have two groups of individuals, military and civilian, and each team has three subgroups, crew chiefs, driver/operators, and...