9 random selections

%3CLINGO-SUB%20id%3D%22lingo-sub-1976285%22%20slang%3D%22en-US%22%3E9%20random%20selections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1976285%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20make%209%20random%20selections%20of%209%20different%20numbers%20from%201-100.%20It%20is%20important%20that%20the%20same%20number%20does%20not%20show%20twice.%20Any%20ideas%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1976285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1976374%22%20slang%3D%22en-US%22%3ERe%3A%209%20random%20selections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1976374%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F897655%22%20target%3D%22_blank%22%3E%40JanSimoni%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20do%20something%20like%20the%20attached.%20It%20could%20be%20made%20more%20sophisticated%2C%20but%20this%20is%20a%20quick%20and%20dirty%20solution%20making%20use%20of%20the%20recently%20available%20UNIQUE%20function%20to%20assure%20no%20duplicates.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHit%20F9%20to%20generate%20a%20new%20list.%20The%20highlighted%20cells%20are%20your%20unique%20nine.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to make 9 random selections of 9 different numbers from 1-100. It is important that the same number does not show twice. Any ideas? Thanks

1 Reply

@JanSimoni 

 

I would do something like the attached. It could be made more sophisticated, but this is a quick and dirty solution making use of the recently available UNIQUE function to assure no duplicates.

 

Hit F9 to generate a new list. The highlighted cells are your unique nine.