Thread: How can I fill a block of 300 cells with non-repeating random #s
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nerkaman nerkaman is offline
external usenet poster
  
Posts: 1
Default How can I fill a block of 300 cells with non-repeating random #s
Using Excel 2003, I've tried RAND and RANDBETWEEN functions but numbers
generated appear to be random to 3 decimal places (even with the cell
formatted for no decimals) and therefore, with 1000 possible outcomes for
each calculation, I end up with numerous, repeated "random" integers in the
block of cells.

This is for a charity fundraiser and I don't wish to fill the cells by
throwing darts, so any help will be greatly appreciated.
Reply With QuoteReply With Quote