Column to Populate the MAX value

Hi,  I have a column comp.description which has the following values: (BLANK, Test, Live, Failed).   I also have a date field comp_date_tested.    What I would like to see the comp.description w...