$6.$ Assign Patient Status in new column based on PatientID column $($IF statement is one possible solution$)$

$7.$ Using data validation, structured table references, and index$-$match, obtain a correct measurement $($height$,$ weight, or BMI$)$ for any patient chosen from a list. Data validation will not accept a structured table reference directly, but you can put a structured table reference in data validation by using the indirect function with a text string that looks like a structured table reference. Use Indirect and text strings that look like structured table references for both the row match and column match. See PatientData!I$8$:J$9$ in solution file.

$8.$ Use COUNTIF to calculate the BMI categories in the BMI Cat column of tblPatients. Count all four BMI categories. See PatientData!I$12$:J$15.$

$9.$ Create a small column chart for BMI categories and make it look like the one in the solution file shown in the PatientData worksheet.