Return Highest Alphanumeric Value

Hi all

I'm stuck on a problem where I'm looking to return in cell BG2, the highest alphanumeric value from 10 non consecutive cells (highlighted yellow)

When I use the MAX function it works fine should I only have numbers in the 10 cells, but the values in the cells very from 1A to 5Z [all instances of these values are shown in a table on sheet2 with their 'scoring']

Any help would be very much appreciated

Hi

Please see attached for one possible way of doing this.

Richard