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
|