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

Thank you bj.

"bj" wrote:

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