When I enter values in a column, the values already there are given as a suggestion for new entry, if they match the start of the string.
There is a script that regularly deletes values from the file, it is done when the workbook is closed.
Is there any way to keep all the historical values from a column as possible suggestions?
So values that are not right now in the column, but were before.