• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

Easy way to get a random sample of data in Excel 2007

Hello:

I have a large data set in excel and I would like to know the quickest (and easiest) way to get a random sample of the data.

The data has several different usernames in a column called "Assigned to" and I need to get 10 random records from each user.  

Thank you in advance.

0
MeowserM
Asked:
MeowserM
  • 4
  • 4
2 Solutions
 
leonstrykerCommented:

Sort by usernames. Use the =RANDBETWEEN() function to generate a random number 10 times and pick those rows as your sample.
0
 
MeowserMAuthor Commented:
Ok that sounds good.  Question for you:  How do I get the bottom and top numbers for each user?

I created a counter for each record within that users "group" of records.  But how do I get the MIN and MAX of that counter?

Thank you for you help
0
 
leonstrykerCommented:
Once you sort your data, then MIN number will be the row where that user's data starts and the MAX number will be where that user's data stops.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
MeowserMAuthor Commented:
Yes and the MIN will always be 1 because that's where I start my counter.  But is there a formula or function I can use to determine the MAX?

0
 
leonstrykerCommented:
The MIN should not always be 1 if it is a sorted list. You can use =COUNTIF() funtion to find how many rows there are for each username, then the MAX will be equal to the MIN + COUNTIF(username)
0
 
MeowserMAuthor Commented:
Very smart.  That's what I was looking for.

 Thank you I need some extra help today.

0
 
MeowserMAuthor Commented:
Thank you again.
0
 
leonstrykerCommented:
Thanks for the grade.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now