Thanks, for takin the time. I will try that? Cheers!

"Chip Pearson" wrote:

I don't believe there is anyway to do this with a formula; you'll need some
VBA code. See http://www.cpearson.com/Excel/randomNumbers.aspx for quite a
few choices. Look at the section entitled "Getting An Array Of Unique,
Non-Duplicated Value" and the UniqueRandomLongs function.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

"RayT" wrote in message
...
Could you kindly assist me with a formula that generate 6 numbers between
1
and 49, without repeating any of the integers.
Thanks!