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

D

DaniMa

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.
 
S

Stefi

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

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

Regards,
Stefi

„DaniMa†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top