Validation rule - 7 letters

[edhunter]

Hello everyone, in need of a validation rule where you can only enter any combination of the 7 letters "fgyaeir" (without replacement). Thus only allowing entry of combination of the 7 letter. e.g. r; eag; ygfaeir; are all valid entries wheres these are not: any letter not in the combination: rp; efgh....etc and if one of the letters is repeated in the entry e.g. rre is not valid since r appears twice.
hope this clarifies, thanks.Book3.xlsx

[wfm007]

Hey,

Required validation has been set on A7


If it works don't forget to click on ***** below the post

[SDCh]

I think this thread same with this :
http://www.excelforum.com/excel-form...7-letters.html

[zbor]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...7-letters.html

Thread Closed.