print highest character number

A

Andy

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
 
S

Stefi

Would you give an example to clarify the task?
Regards,
Stefi


„Andy†ezt írta:
 
R

Ron Rosenfeld

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
Click to expand...

The *array* formula:

=MAX(LEN(rng))

where rng is your range of cells to test.

To enter an *array* formula, after typing it in, hold down <ctrl><shift> while
hitting <enter>. Excel will place braces {...} around the formula.


--ron
 
R

Roger Govier

Hi Ron

Just one small caveat for the OP, range cannot be a whole column.
I had thought that would be the solution, and tried {=MAX(LEN(A:A))}
which failed with a #VALUE error.
Changing the range to A1:A65536 resolved the problem.
 
R

Ron Rosenfeld

Hi Ron

Just one small caveat for the OP, range cannot be a whole column.
I had thought that would be the solution, and tried {=MAX(LEN(A:A))}
which failed with a #VALUE error.
Changing the range to A1:A65536 resolved the problem.
Click to expand...

I don't think so. You would have to change the range to A1:A65535.

This is clearly laid out in Excel's Specifications.

Also note that this is not a size limit, merely a limit on using an entire
column. For example A1:B65535 would be valid.


--ron
 
Top