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