Validation

[smugcat]

I have a repeating field which was initially just text. Now any new entries come from a looked-up list. Is there any way to validate entries which occurred before the new validation, ie find any entries that are NOT from the looked-up list but were typed in.

[zincb]

Attached is a simple file that does what you want, using the "EXACT" function, and by replacing the paragraph returns with a "pipe" character, so the list can be manipulated. It works for both exact case matching and for case-insensitive matching. To expand for a repeating field, use the GetRepetition function in an inner Loop.

data_validation.zip