I have a database that contains among everything else...a list of items numbers and a list of associate names aligned to those item numbers. I am trying to take a sample of 2 items that each associate produced. So in theory, if Sally produced 10 items (Items: 1001, 1203, 4503, 4542, 4555, 5555, 5612, 6564, 8832, 9222) and I wanted to randomly pull 2 of those items out based on just Sally's name (among all my list of associates), how can I formulate a formula to do so? Anyone? Thanks!
Josh
How are you getting those 10 items from Sally?
One way to randomly choose something in a list would be
=CHOOSE(randbetween(1,10),CHOICE1,CHOICE2,CHOICE3,.....CHOICE10)
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Those 10 are in my company's data source every morning.
The CHOOSE formula would only provide for a select number (2 in this case) for just Sally, right? But what if I needed to go each associate by each associate and there are 1000 associates that I need to pull 2 from?
So, if you look at the attachment. I need to randomly choose 2 Item Numbers for Janell Abraham, 2 for Angelina Acosta, 2 for Mark Adler...so on and so on...
Any suggestions?
Thanks!
Josh
This assumes you have NAME, item1, item2, ...
Alter as you wish.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks