View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RMort RMort is offline
external usenet poster
 
Posts: 7
Default Selecting a Random Sample of 15 from a Large data set

I need to pull a random sample of data from very large list of names
Here are the column headers

LAST_NAME GROUP SEQ ENTERED_DATE

I need to randomly pull 15 "GROUP_SEQ" for each last name in the list
Can anyone figure out a way to do this?

Thanks in advance.
Rick