Validation rule - 7 letters

**edhunter** · 03-11-2013, 02:53 AM

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** · 03-11-2013, 09:54 AM

Hey,

Required validation has been set on A7

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

**SDCh** · 03-11-2013, 10:02 AM

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

**zbor** · 03-11-2013, 10:07 AM

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.