Hi everyone
I have four non adjacent cells A1, A3, C1 and C3. Each cell contains a risk value of either "low", "medium", "high" or "extreme".
I'm looking for some help with efficient code (Excel 2007) to validate the values in these cells, and record the highest level of risk in a variable called say "MaxRisk".
I can achieve it with a bunch of messy IF tests (I have multiple series of these four cell clusters) but can't help thinking there has to be a smarter way.
Hope someone can help.
Kind regards,
HappyHole
Bookmarks