Excel random sort in one column. only 10 to 50 numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-3217723%22%20slang%3D%22en-US%22%3EExcel%20random%20sort%20in%20one%20column.%20only%2010%20to%2050%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217723%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3ETrying%20randomly%20sort%20numbers%20in%20a%20column%20from%201%20to%2050%20with%20no%20duplicates.%20I've%20tried%20RANDOMARRAY%20but%20that%20returns%20a%20random%20number%20for%20each%20cell%20and%20there%20are%20duplicates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3217723%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217747%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20random%20sort%20in%20one%20column.%20only%2010%20to%2050%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217747%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318664%22%20target%3D%22_blank%22%3E%40Chris144%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3EIn%20the%20attached%20file%20in%20cell%20A1%20you%20can%20enter%20the%20number%20of%20random%20numbers%20which%20will%20be%20displayed%20in%20range%20A3%3AA54.%20Click%20the%20button%20in%20cell%20D2%20to%20start%20the%20macro.%20Maybe%20this%20is%20what%20you%20want%20to%20do.%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there,

Trying randomly sort numbers in a column from 1 to 50 with no duplicates. I've tried RANDOMARRAY but that returns a random number for each cell and there are duplicates.

3 Replies

@Chris144 

In the attached file in cell A1 you can enter the number of random numbers which will be displayed in range A3:A54. Click the button in cell D2 to start the macro. Maybe this is what you want to do.

 
 

@Chris144 As a variant, the following formula will create a randomly sorted list of numbers from 1 to 50 without duplication.

 

=SORTBY(SEQUENCE(50),RANDARRAY(50))

 

Thanks so much. I eventually used the RAND function and that sorts it out fine. Took me a while to work out how to use it!!
Thanks,
Chris