View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy
 
Posts: n/a
Default print highest character number

HI,

I need to print in a cell the highest character count from a cell among the
selected cell. for example if i select 500 cells in a column and supposed 3rd
column has 200 characters in it, which is the highest among all the selected
cells, i need 200 to be displayed automatically in some cell. I could not
find a relevant formula that will take care of this. Please let me know if
there is some way i can achieve this.

Regards