mixing numbers up

**Duckie** · 07-28-2009, 12:26 AM

hi can any one help me with the following

i have numbers that are the same but i would like them mixed up with at least 9 differance numbers in a column
continuing down the column but all nine positions must be filled the number are always differance i hope this makes sense
as per file attached

**martindwilson** · 07-28-2009, 06:28 AM

one way(not sure from your example whether you wanted repeats or not so i did no repeats)

**Duckie** · 08-02-2009, 01:15 AM

hi i have tried that martin but i could only get a few more numbers i have included your file to show you what i have done

**martindwilson** · 08-02-2009, 06:08 AM

nope now it doesnt make sense at all!
what do you mean by

continuing down the column but all nine positions must be filled the number are always differance

i see you have colured in some sections whats supposed to go in them?
is each one a set of nine random unique numbers? taken from the list in column B ?

**Duckie** · 08-02-2009, 06:33 AM

sorry i am bot explaining myself its column A is the random numbers i need

**martindwilson** · 08-02-2009, 06:49 AM

can you give a manual example of what its suposed to look like?
or do you just want those numbers in col a split into 6 random groups of 9 so if you have say 123 5 times it must only appear 5 times across all the groups?
if its that seee attached