Is there an Excel formula to show the highest letter in a row?
 

I am trying to compile a list of drawings we receive, which are referenced A,
B, C or 1, 2, 3 etc (from different sources). It correlates to the date it is
received eg:
Date 02-02-09 10-02-09 20-02-09 05-03-09
08-03-09
Revision A B
C
Revision 1 2

Is there a formula so that I can have one column which always displays the
most current revision, and automatically updates when that column is amended?
Also, every cell is not amended for each date ie sometimes we only get two
drawings so all the other cells are left blank in that column.

Is there an Excel formula to show the highest letter in a row?
 

=CHAR(MAX(CODE(B2:D2)))

entered as an array formula (confirmed with Ctrl+Shift+Enter)

Regards,
Stefi

€žDaniMa€� ezt Ã*rta:

I am trying to compile a list of drawings we receive, which are referenced A,
B, C or 1, 2, 3 etc (from different sources). It correlates to the date it is
received eg:
Date 02-02-09 10-02-09 20-02-09 05-03-09
08-03-09
Revision A B
C
Revision 1 2

Is there a formula so that I can have one column which always displays the
most current revision, and automatically updates when that column is amended?
Also, every cell is not amended for each date ie sometimes we only get two
drawings so all the other cells are left blank in that column.