View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Spencer Spencer is offline
external usenet poster
 
Posts: 29
Default football squares

Since CRS wrote "football squares" as the subject, I'm betting he wants 0
through 9 going across the page, and 0 - 9 in column A as well. :-)
Of course, gambling is illegal in most states, so I'm sure this "sheet" is
just for fun.
;-)
SpenCer

"Sheeloo" wrote:

Requirement is not clear.

What is the size of the string? How many strings you want?

"CRS" wrote:

I am in need of a formula or function to generate a random string containing
the integers 0-9, with no repitition. I have tried using RANDOM and
RANDOMBETWEEN, but am not sure how to avoid repition.