Random Sample to Pull One Record per User

[SoldOnTheRoad]

Scenario - I have 10 employees, who complete 10 sales per day. My data refreshes each day, so it's just prior day information.

I would like to randomly pull 1 transaction per employee to perform an audit.

I am comfortable creating a random sample, but not applying a one per user idea.

 

[LeBen James]

I would assign each transaction an random number using rand(). Then I would on a separate sheet use =Max(IF(Range of Employees = Employee, Random Value)) for each employee to pull the highest random number assigned to each employee. From there it becomes a VLOOKUP or INDEX/MATCH project to pull the remaining information about the transaction to the sheet.

 

[SoldOnTheRoad]

I would assign each transaction an random number using rand(). Then I would on a separate sheet use =Max(IF(Range of Employees = Employee, Random Value)) for each employee to pull the highest random number assigned to each employee. From there it becomes a VLOOKUP or INDEX/MATCH project to pull the remaining information about the transaction to the sheet.

That =max(if option isn't a complete formula.