randbetween different than

Hi Guys,

I was trying to put a formula down to give me in one line of six cells a random number between a range of numbers (the same range for all cells) but in each cell the number to be different than in the others.

So if the range would be 1-99 then let me say:

5 66 24 ...

I have tried for the first cell:

=randbetween(1,99)

for the next one I tried:

=if(randbetween(1,99)=cell1,randbetween(1,99),randbetween(1,99))

hoping that it will exclude the previous result.

Even when living a static value in cell one the cell two came back occassionaly with the same number.

Would anyone of you know if there is an alteration to that formula that I can use ar maybe a macro with connection to some formula to live values only when all the numbers deffire from each other?

I know how to make macro for values only but only bassed on selection / copy / paste special / values only. Don't know if there is a way to give conditions to copy.

Thanks for reading and giving it a go.