Autocomplete - Maximum Data Range

Hi Keith and welcome to the board.
I don't know the answer to this, but I was intrigued, and tried to replicate it.
I filled rows 1-3000 with "x" and then put the whole alphabet into A1, and then experimented to see how many characters you needed, to get Auto Complete to work.
Here's the results.
Rows 2-51 (inclusive) - 1 character, i.e. typing "a" returned a suggested "abcde..."
Rows 52-101 - 2 characters, i.e. I had to type "ab" to get the correct suggestion.
I didn't actually do it all the way down, but I'm guessing a similar pattern appears.
I'm guessing this is deliberate, on the grounds that the further away from the source you are, the less likely you are to intend the same text string.
I also noticed that these bands weren't actually consistent.
For example, around row 90, sometimes you needed 2, sometimes 3, and it seemed to be partly dependent on my speed of typing.

Not sure if this helps you - I too would be interested in the "official" version.

Hi Gerald..........

Thanks for the progress you made with this puzzle.

I repeated your test with 'A-Z' in A1 and 'x' in every cell down to A3000.

I started to type in the alphabet into A2998 and AUTOCOMPLETE was activated when I had typed in 'A-X'.

There must be a rule. Any idea how to get to the bottom of this?

Regards.............. Keith T