View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Aiston[_2_] Trevor Aiston[_2_] is offline
external usenet poster
 
Posts: 17
Default Selecting Random Records From an Excel Sreadsheet

I have a workbook which contains 300 records from which I wand to be able to
randomly select 50 records. Each record has a geographical area attribute
(e.g. east, west etc) and I have worked out proportionality how many per
geographical area I want to select, but not sure how to randomly select, e.g.
3, from each subset of data. Hope this is clear.

Any suggestions

Trevor