Highest Value in Row, Including Letters and Numbers

I can't view PNG files on my computer, so I'll try a guess.

With these values in A1:P1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

1

E

A

O

A

3

D

N

I

I

1

E

J

L

E

N

3

And this list in S1:S24

	S
1	A
2	B
3	C
4	D
5	E
6	F
7	G
8	H
9	I
10	J
11	K
12	L
13	M
14	N
15	O
16	1
17	2
18	3
19	4
20	5
21	6
22	7
23	8
24	9

This formula returns the highest ranking item:

=INDEX($S$1:$S$24,MAX(INDEX(MATCH(A1:P1,$S$1:$S$24,0),0)))

or...using hard-coded arrays

=MID("ABCDEFGHIJKLMNO123456789",MAX(INDEX(MATCH(A1:P1
,{"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";1;2;3;4;5;6;7;8;9},0),0)),1)

In that example, both formulas return: 3

Is that something you can work with?

As you can see by the spreadsheet, I think I am missing out on something. I do see that you have 2 parts to your formula so do I need to reference the header line (AC3 to AU3) then the row (AC5 to AU5)?

Try this array formula*:

=INDEX(AC5:AU5,0,MAX((AC5:AU5<>"")*(COLUMN(AC5:AU5)-28)))

*Array formulas are activated with the keystrokes Ctrl + Shift + Enter (not just Enter).
Let me know if you have any questions.

You got the #value error because the formula was activate by Enter (or pasting) only. After pasting the formula into the cell press F2 and then use the keystrokes Ctrl + Shift + Enter. Here is a copy of your file with the formula applied:
Copy of Architectural_1.0.xls
Let me know if you have any questions.

try below copy paste and simply hit enter
=LOOKUP(2,1/(AC5:AU5<>""),AC5:AU5)

Select AV5, press and release the function 2 key (F2) then press and hold the Ctrl, Shift and Enter keys at the same time.
Let me know if you have any questions.

@ Betty thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.