Random Integer - ExcelBanter

Posted to microsoft.public.excel.newusers

Don[_4_]

external usenet poster

Posts: 11

Random Integer

I need to create a unique random number from 1-15 in columns D1 thru D15.
There can be no duplicates. It should be a different set of numbers each
time the spreadsheet is loaded. Can someone show me an easy way to
accomplish this?

Don D.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting random Data created from a random formula	Six Sigma Blackbelt	Excel Discussion (Misc queries)	1	September 11th 08 11:03 PM
integer	integer format	Excel Worksheet Functions	1	May 3rd 07 06:45 PM
Non-random numbers generated by excel's data analysis random gener	Allie	Excel Worksheet Functions	10	September 17th 05 06:19 AM
Non-random numbers generated by excel's data analysis random gener	Harlan Grove	Excel Discussion (Misc queries)	2	September 13th 05 04:06 PM
How do I find random number in list of random alpha? (Position is.	jlahealth-partners	Excel Discussion (Misc queries)	0	February 8th 05 05:31 PM

All times are GMT +1. The time now is 03:04 PM.

Menu

About Us