Formulae help please?

[Andy Moore]

Hi,

I have a =rand()25 formula entered into a cell, which is copied across the row. Is there a way that I can tell the formula not to repeat the rand result in the whole row?

Many thanks

Andy

 

[Andy Moore]

Absolutely brilliant effort guys. Many thanks for this. I did think it would be easier than this though!

Regards,

Andy

 

[lundbhaiz]

this is not so easy. you was fortunate to get help on this ultra hard formula very easy