Thread: highest value between rows
View Single Post
  #6  
Old March 23rd, 2010, 05:49 AM posted to microsoft.public.excel.newusers
FORMULA
external usenet poster
  
Posts: 9
Default highest value between rows

i forgot something.. let's say datas a

A B C D E F G
1 AA08 AA18 AB03 AA30 AB15 AC01
2



It's determining highest alpha numeric values.

Value to be displayed in G1 must be the highest alpha numeric which is AC01.

Pls advise.

Thanks.