Comparing TEXT values
Very simple task from the looks of it.
I have a line item where user (or formula, I don't think it matters) enters text. I want this text be unique, and if it isn't - I want user to know about it. How do I make a check?
If it were cells formatted as list members - I can think of a way to compare those, but many functions do not work with text fields.
Any ideas are appreciated.