Hi. I need to use a MAX IF formula that has a mix of 0, 1, A, B, 2, 3, 4, 5, 6, etc. It only has a couple of A's and B's mixed in with the numbers, but it's enough to mess up the formula. Ideally I would like to combine the MAXIF formula (which works just great when there are no letters), and tell it to substitute any A's for 1 and B's for 2. I've searched the forums and can't find a solution so any help would be very much appreciated.

i.e.

Purpose AEEAAAAAA
Revision 01B345678

Look for highest Purpose 'E' = Revision 'B'
Look for highest Purpose 'A' - Revision '8'

Many thanks!