LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default draw 999 x 8 random records from file with 8614 records

Dear Group,

I am looking for a script which can draw 999 x 8 random records from an
excel file with 8614 records. The file should eventually look like this:

record long lat
001 15.36 -2.26
001 25.56 -25.36
001 24.36 25.36
001 15.48 36.15
001 14.69 25.78
001 24.69 26.14
001 etc.
001
002
002
....
....
....
999
999
999
999
999
999
999
999

Can anybody help me with this? Regards,

Niels


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
select random sample of records in a filtered list David3553 Excel Discussion (Misc queries) 2 November 25th 09 11:37 PM
Selecting Random Records From an Excel Sreadsheet Trevor Aiston[_2_] Excel Worksheet Functions 3 June 29th 09 11:20 AM
Delete records when certain records have duplicate column data JVroom New Users to Excel 1 January 26th 09 06:23 PM
how do I download a csv file with 100,000 records into excel? Lauren Excel Discussion (Misc queries) 6 March 9th 06 11:59 PM
selecting random records terry freedman Excel Programming 2 April 2nd 04 11:07 AM


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"