Pick random names from .csv file

**atorres0506** · #1 21st Jan 2009, 12:42

Hello,

I am currently working on a project for my company using an auto dialer system. Say I have a .txt or .csv file with 80,000 records. I need to find “x” (where x could be 15,000) random people in that database.

How would I go about doing this,

Thank You!

**Razer** · #2 21st Jan 2009, 14:58

I dont think Excel has a feature to do this, you're looking at a 3rd party program..

**Glaswegian** · #3 21st Jan 2009, 15:13

Hi

Excel does have a RAND function (which is fairly close to being random) - you would probably need to import the file first.

If you are using XL2007 then the import will not be a problem, but if using any earlier version, you might want to look at Chip Pearson's site for code to import large text files.

http://www.cpearson.com/excel/ImportBigFiles.aspx

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ms-dos Application Being Saved Under My File Names	ahren	Windows Operating Systems	0	6th Jun 2009 04:49
Pick A Motherboard/GPU Combination!	Rapolyne	General Hardware Chat	4	5th Nov 2008 01:22
PLEASE, help me pick a laptop!	Old Chipper	Laptops, Mobiles & PDAs	2	6th Jun 2008 05:35
$200 mobo .... PICK ONE!!! plz	ali1	CPUs, Motherboards & RAM	5	27th Nov 2007 14:58
Program that selects one file from a folder at random?	andrewanimation	General Software Chat	6	25th Nov 2007 17:16