Edit Auto Complete in Numbers

There is no user control of the suggestion list except the preferences choice to use it or not. If checked in Numbers preferences, the list it presents is automatically built from the current values in that column.

How many rows in the table? Are there any hidden rows?

Sometimes a search by formula will catch things we miss.

Assuming the issue is in column B, here's a formula you can place in an added temporary column on the table. I the example below, it has been entered in G2, and filled down to the last row of the table.

G2: FIND("IL",B2)

Filled down in the sample table, the formula throws an error in rows where it does not find "IL", and 2, indicating the string was found, starting at the second character in cells containing "NIL"

Regards,

Barry

I suggest making a copy of the column in another column (to preserve what you have now).

then delete half the column

check to see if the offending entries are still in the list when you type in a new cell

If they are, then delete half of the remaining. if not, then undo the delete and remove the other half of the table. repeat as needed

I tried a sequence of typing and observing what is in the suggestion list:

Enter "N" and "Nil"

then in a third cell type "N" to observe list

Add a cell with "NIL" then in another cell enter "N" to observe the list:

Remove entries except for "NIL", then type "N" to observe the list

Add a cell with "Nil" then type "N" in another cell to observe list

Add "N" in a new cell then type "N" in another cell to observe the list

The Suggestions feature suggests all existing entries that are in the same column and match what you have entered so far in the current cell.

If you are getting an incorrect suggestion, it means that incorrect entry already exists in at least one cell in that column. You edit the suggestions by finding and fixing that existing entry.

Regards,

Barry

Good followup. Newer versions than mine may hang on to those entries even after deleting the errors. Reboting does clean out some crud, and I suspect the lists may also be recreated when the document is next opened.

Regards,

Barry

I'm using Numbers 6.2.1 on mac OS X 10.14.6