software

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.

RegardsWould you give an example to clarify the task?
Regards,
Stefi?ndy??ezt ?rta:

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

On Fri, 6 Jan 2006 02:35:02 -0800, quot;Andyquot; gt;
wrote:

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

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 lt;ctrlgt;lt;shiftgt; while
hitting lt;entergt;. Excel will place braces {...} around the formula.--ron

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.

--
Regards

Roger Govierquot;Ron Rosenfeldquot; gt; wrote in message
...
gt; On Fri, 6 Jan 2006 02:35:02 -0800, quot;Andyquot;
gt; gt;
gt; wrote:
gt;
gt;gt;HI,
gt;gt;
gt;gt;I need to print in a cell the highest character count from a cell
gt;gt;among the
gt;gt;selected cell. for example if i select 500 cells in a column and
gt;gt;supposed 3rd
gt;gt;column has 200 characters in it, which is the highest among all the
gt;gt;selected
gt;gt;cells, i need 200 to be displayed automatically in some cell. I could
gt;gt;not
gt;gt;find a relevant formula that will take care of this. Please let me
gt;gt;know if
gt;gt;there is some way i can achieve this.
gt;gt;
gt;gt;Regards
gt;
gt; The *array* formula:
gt;
gt; =MAX(LEN(rng))
gt;
gt; where rng is your range of cells to test.
gt;
gt; To enter an *array* formula, after typing it in, hold down
gt; lt;ctrlgt;lt;shiftgt; while
gt; hitting lt;entergt;. Excel will place braces {...} around the formula.
gt;
gt;
gt; --ron
On Fri, 6 Jan 2006 12:49:06 -0000, quot;Roger Govierquot;
gt; wrote:

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

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

Quite right Ron, it was 65535 I used, not 65536.

--
Regards

Roger Govierquot;Ron Rosenfeldquot; gt; wrote in message
...
gt; On Fri, 6 Jan 2006 12:49:06 -0000, quot;Roger Govierquot;
gt; gt; wrote:
gt;
gt;gt;Hi Ron
gt;gt;
gt;gt;Just one small caveat for the OP, range cannot be a whole column.
gt;gt;I had thought that would be the solution, and tried {=MAX(LEN(A:A))}
gt;gt;which failed with a #VALUE error.
gt;gt;Changing the range to A1:A65536 resolved the problem.
gt;gt;
gt;gt;--
gt;gt;Regards
gt;gt;
gt;gt;Roger Govier
gt;
gt; I don't think so. You would have to change the range to A1:A65535.
gt;
gt; This is clearly laid out in Excel's Specifications.
gt;
gt; Also note that this is not a size limit, merely a limit on using an
gt; entire
gt; column. For example A1:B65535 would be valid.
gt;
gt;
gt; --ron