What formula would I use to find the highest alphabetical character in a row?
B Bradbell Apr 14, 2008 #1 What formula would I use to find the highest alphabetical character in a row?
B Bradbell Apr 14, 2008 #3 Highest meaning the closest to Z Jim Thomlinson said: Define Highest. The value closest to a or to z??? Click to expand...
Highest meaning the closest to Z Jim Thomlinson said: Define Highest. The value closest to a or to z??? Click to expand...
G Gord Dibben Apr 14, 2008 #4 Characters in row 1 In A2 enter =CODE(A1) Copy/drag across. In A3 enter =MAX(2:2) Gord Dibben MS Excel MVP
Characters in row 1 In A2 enter =CODE(A1) Copy/drag across. In A3 enter =MAX(2:2) Gord Dibben MS Excel MVP