Hi,

I'm trying to get a validation on cells A1:A10 where you can only put a 4 digit number + a letter that is determined by the mod(4digitnumberinput;5)+1 where depending on value: F=1;N=2;R=3;T=4;X=5. What is/are the formulas i can use to get this result.

Much appreciated,