combine set of letters randomly

hi,

is it possible to combine 8 letters (for example) randomly, i mean to
generate different combinations from these 8 letters? please help

yob

On Fri, 16 Sep 2005 15:57:40 +0800, "rp" <[email protected]> wrote in
microsoft.public.excel:

>is it possible to combine 8 letters (for example) randomly, i mean to
>generate different combinations from these 8 letters? please help

This has been covered not so long ago in
<http://groups.google.com.au/group/microsoft.public.office.misc/browse_frm/thread/8d6139cc43ce052d/250c38d50a17e0dd>.

Note that 8 letters will yield 40320 permutations.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

This solution assumes repeat letters are not a problem.

the CHAR function will return a character from a number within a range
65-90 is A - Z
97-122 ia a-z

therefore if you use the ATP function
=CHAR(RANDBETWEEN(65,90))
you will get a single letter

=CONCATENATE(CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)))

Ugly but it does what it says.

hth RES

http://www.j-walk.com/ss/excel/tips/tip46.htm

"rp" wrote:

> hi,
>
> is it possible to combine 8 letters (for example) randomly, i mean to
> generate different combinations from these 8 letters? please help
>
> yob
>
>
>