Hi,

I am wanting to count the max length of data (text and numeric) in a huge
data set. I need to know this information by column so thinking along the
lines of
=LEN(C182:C189) which of course does not work.

Can anyone suggest something?

You can use an array formula like

=MAX(LEN(A1:A10))

This is an array formula, so after you type the formula, press
CTRL+SHIFT+ENTER rather than just ENTER. If you do this correctly, Excel
will display the formula enclosed in curly braces {}.

I

"Little Pete" wrote in message
...
Hi,

I am wanting to count the max length of data (text and numeric) in a huge
data set. I need to know this information by column so thinking along
the
lines of
=LEN(C182:C189) which of course does not work.

Can anyone suggest something?

Try:

=max(len(c182:c189))

But use ctrl-shift-enter instead of just enter.

Little Pete wrote:

Hi,

I am wanting to count the max length of data (text and numeric) in a huge
data set. I need to know this information by column so thinking along the
lines of
=LEN(C182:C189) which of course does not work.

Can anyone suggest something?

--

Dave Peterson

try

=max(LEN(C182:C189)) entered with Ctrl-Shift-Enter


"Little Pete" wrote:

Hi,

I am wanting to count the max length of data (text and numeric) in a huge
data set. I need to know this information by column so thinking along the
lines of
=LEN(C182:C189) which of course does not work.

Can anyone suggest something?

Numbers will need a decision if you want them formatted a certain way.
For example:

The value 1234.56 may be displayed as: 1234.560
If you don't care if the trailing zeros are counted in length,

With this list in A1:A10
Albany
Albuquerque
Boston
Chicago
Sacramento
123.08
New Orleans
Denver
1234
123456789.012


This regular formula returns the maximum cell contents length for that range
B1: =MAX(INDEX(LEN(A1:A10),0))

In that example: the Max is 13 (the length of 123456789.012)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Little Pete" wrote:

Hi,

I am wanting to count the max length of data (text and numeric) in a huge
data set. I need to know this information by column so thinking along the
lines of
=LEN(C182:C189) which of course does not work.

Can anyone suggest something?