Hi, I need a formula that will allow me generate random letter between A-D (A,B,C,D). However, this random letter must not be the same as the letter in the cell before.
For example, in A1 I had the letter "B", in A2 the random letter should be any of the following ("A","C","D")
Solved by V. Y. in 27 mins