var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
i have an excel spreadsheet that has > 1000 rows (records). i'd like to randomly select 78 of these rows and place them in another worksheet w/in this file.
ok, i've gotten a little further, but...
i went to Tools > Data Analysis > Sampling, and i can get 78 random records, selecting the column "id," when is a number field. but the accompanying columns that are text are not coming along with it. any thoughts here?
got a little further. am able to do it w/the rand() function and an advanced filter. but, can get, say 10% of records. i want a specific number of records. any thoughts?
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors