Thread: Formula to find highest alphabetic name in a list of names
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Formula to find highest alphabetic name in a list of names
Domenic wrote...
Try...

=INDEX(A2:A10,MATCH(0,IF(A2:A10<"",COUNTIF(A2:A1 0,""&A2:A10)),0))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
....

You could shrink that to the nonarray formula

=LOOKUP(2,1/(COUNTIF(A2:A10,""&A2:A10&"*")=0),A2:A10)

Reply With QuoteReply With Quote