![]() |
|
|||||||
|
|
|
|
|
|
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 ...
|
![]() |
|
|
Thread Tools |
|
#1
|
|||
|
|||
|
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! |
|
#2
|
|||
|
|||
|
I dont think Excel has a feature to do this, you're looking at a 3rd party program..
|
|
#3
|
||||||||||||
|
||||||||||||
|
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
__________________
__________________
Iain - Defender of the Haggis Member of ASAP : : Member of UNITE My System: It's all mine...
|
![]() |
|
| Bookmarks |
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 |
| Thread Tools | |
|
|