What function do I use to capture the highest risk rating
I have a riks register that includes a column for a rating eg critical, high, medium or low.
I want to surface to another sheet/report/dashboard a summary of all risks in the risk register as 'Risk health'. My thinking is that this woudl be the highest rating of al in the register.
What function would I use to determine from a column of rating such as those listed above what the highest is?
Alternatively the Risk health could the 'average' rating but (a) views on relevance and (b) what function to use are sought.