Hi,

I cannot get my head round letter sequences (seriously I've tried)

What you have is the full alphabet and increasing in value I can do..

e.g. D ,G, J, M, P (You will start the alphabet again if you reach the end).

What I'm pulling my hair on is going backwards especially when you have to start all over again.

e.g I, D, Y, T, O

What I was thinking something along the line of:

IF(65+C14+(3*D14)<=90,CHAR(65+C14+(3*D14)),CHAR(65+((C14+(3*D14))+65)-91))

The following are found in C14 and D14,..

rnd no seq no
20 5

The above are generated at random.

Hope you guys can help..