Hi,

What is the maximum number of unique strings in Excel 2003?

I have estimated it as 2^23-128-1 = 8,388,479.

Is that correct?

John.
--

I don't agree with yoiu formula or answer.

L = Longest length string
N = Number of different characters

Answer = N^L

There are a possiblilty of 256 ASCII characters. You havve to count which
charracters you arre using.

On a worksheet you can see up to 256 characters, but the string length can
be 32K.

" wrote:

Hi,

What is the maximum number of unique strings in Excel 2003?

I have estimated it as 2^23-128-1 = 8,388,479.

Is that correct?

John.
--

Wrong:

Just 5 character string of alphabetics is:

=26 * 36 * 26 * 26 *26

11,881,376

--
Gary''s Student - gsnu2007a


" wrote:

Hi,

What is the maximum number of unique strings in Excel 2003?

I have estimated it as 2^23-128-1 = 8,388,479.

Is that correct?

John.
--

On Oct 31, 10:16 am, wrote:
What is the maximum number of unique strings in Excel 2003?

Given the initial replies, I should clarify:

What is the maximum number of unique strings *supported by* Excel
2003?

Adding more than 8,388,479 unique strings appears to make Excel crash.

John.
--

Hi John,
There is no published limit. I suppose that, like many other "limits" one could think of, it depends on how you create them
(formulas? Import? manual entering?) and available memory.
But I downloaded a workbook containing the complete King James' Bible:
http://j-walkblog.com/index.php?/web...ible_in_excel/

You might want to try and explain what you're trying to achieve and what behavior of Excel won't let you

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


wrote in message ups.com...
| On Oct 31, 10:16 am, wrote:
| What is the maximum number of unique strings in Excel 2003?
|
| Given the initial replies, I should clarify:
|
| What is the maximum number of unique strings *supported by* Excel
| 2003?
|
| Adding more than 8,388,479 unique strings appears to make Excel crash.
|
| John.
| --
|
|

On Oct 31, 12:52 pm, "Niek Otten" wrote:
Hi John,
There is no published limit. I suppose that, like many other "limits" one could think of, it depends on how you create them
(formulas? Import? manual entering?) and available memory.
But I downloaded a workbook containing the complete King James' Bible:http://j-walkblog.com/index.php?/web...ible_in_excel/

You might want to try and explain what you're trying to achieve and what behavior of Excel
won't let you


Hi,

There isn't any real world application for this. I was just curious if
this is a known limit. It isn't mentioned is the usual "Excel
specifications and limits".

BTW, that copy of the King James Bible has only 62,018 unique
strings. :-)

John.
--