View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ExcelMonkey
 
Posts: n/a
Default Find max number of character and return cell address

I have a range of cells from E18:E21 that look like this:

?
?
?3?
?3?4?

I want to return the cell address of the cell which has the max numbers of
"?". So its like a lookup on the range E18:E21 with the search argument
looking for the most number of "?". But then I want to return the cell
address E21.

Thanks