Posted to microsoft.public.excel.worksheet.functions

Paul

external usenet poster

Posts: 661

RANDBETWEEN()

I'm using the formula =RANDBETWEEN(1,15)
to generate random numbers in cells A2 through A6.
I don't want any of those random numbers to be repeated.
Any suggestions on how to do this?
Thanks for your help.

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
RANDBETWEEN	Jerm	Excel Worksheet Functions	15	September 7th 09 02:27 PM
Randbetween	Steve Moss	Excel Discussion (Misc queries)	1	July 30th 07 09:50 AM
randbetween(1.1,1.25)	Deniz	Excel Worksheet Functions	3	July 10th 07 04:40 PM
RANDBETWEEN	pkeegs	Excel Worksheet Functions	6	April 27th 07 01:12 AM
randbetween	[email protected]	Excel Discussion (Misc queries)	1	November 21st 05 01:25 PM

All times are GMT +1. The time now is 06:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us