Data Validation

[wrathastorm]

Hi

I have a team whose work is split alphabetically, each person has their own alpha split and associated workbook. I need to be able to restrict their input to only names within their split anything else should produce an error. eg 1 person has an alpha split for M - Mi.
I have tried a few combinations with no success eg =countif(b3,"ma-*")+countif(b3,"mb-*")+ etc
Any help would be greatly appreciated.

 

[Scott T]

Try

=IF(AND(LEFT(SUBSTITUTE(A3,"'",""),2)>=LEFT("MA",2),LEFT(SUBSTITUTE(A3,"'",""),2)<=RIGHT("MI",2)),TRUE,FALSE)

I have the substitute to remove any ' incase you have a name like O'Brien

 

[wrathastorm]

Scott T. many thanks worked perfectly!