At the practice I work at all drawings go through a cycle of revisions. With A-Z being lowest order, then P1-P100, then B1-B100.

In short, a row of data may look like the following:

A,B,C,D,P1,P2,P3,P1,B1,B2,B3,P1

Now, I would like to be able to extract the 'highest' value which in this case would be B3.

I can get Excel (Mac 2008) to find the furthest right value, but that is not always the 'highest' as you can see.

Any help would be much appreciated!