ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I use the random function? (https://www.excelbanter.com/excel-worksheet-functions/34756-how-can-i-use-random-function.html)

petevang

How can I use the random function?
 

I have a list of 150+ accounts and I'm trying to use excell to randomly
select 14 of the 150+. Is this Possible? and if so how do I set up the
function. Thanks Pete


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=386118


JE McGimpsey

Use the first technique he

http://www.mcgimpsey.com/excel/randint.html


In article ,
petevang
wrote:

I have a list of 150+ accounts and I'm trying to use excell to randomly
select 14 of the 150+. Is this Possible? and if so how do I set up the
function. Thanks Pete



All times are GMT +1. The time now is 08:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com