Hi,
Our pivot table shows some managers and some employees under the given manager. Every employee has some case numbers, what we need is to choose 5 random case number for each employee and list the data with case IDs and other stuff related with those case IDs in the another worksheet.
Any help would be appreciated. Thank you.
Hi,
One way would be to create a new column in your data and add the formula =RAND() on all the rows.
Now, probably with a looping macro,
1. Use Data Filter to filter all the records including the random value for an employee to a temporary holding area.
2. With this temporary set of records filter this for the top 5 values in the random column.
3. Copy the 5 filtered rows to the destination sheet.
Repeat 1-3 for each employee
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks