View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Need to find the higest alpahbetic name in a list of names

there are several methods, depending on what you want to do with the data.
a simple way is top use <data<filter<Autofilter and just select the
highest name

"Carlo" wrote:

Hi there,

I have a list of names like Andrew, Zachary, Jeff etc and I need to find out
which one is the highest alphabetically. The max function doesn't seem to
work.

Is this possible?

Thanks

Carlo