Lois Patterson, in her book 'Teach Yourself Excel 97' sets an exercise to
create a Lottery Number selector with a set of six random numbers.
=INT(45*RAND)+1 This is fine and easily done.
It goes on to say that by using the IF function it is possible to prevent
the generated numbers being duplicated in the set. After weeks of
frustration I am unable to solve this problem. Please can anyone help?