Pick a row randomly for each user

sunilbsrv2k

Board Regular
Joined
May 25, 2018
Messages
55
Hi All,

I am having a set of data containing several rows and columns.

This data contains "User Name" in one of the columns; however another column contains the Date on which he accessed a document. One more column has this document ID.

Now, I need to randomly pick the entire row for each of the users but needs to be one row per day per user. It should cover for all the users of that day and paste it in a new sheet.

Request you to kindly help.

Thanks
 

sunilbsrv2k

Board Regular
Joined
May 25, 2018
Messages
55
Hi,

I guess I have complicated my question.

In short, I want my code to pick a row randomly based on the username and the date.

Please help.

Thanks,
 

Forum statistics

Threads
1,077,633
Messages
5,335,371
Members
399,014
Latest member
hamzalaarif

Some videos you may like

This Week's Hot Topics

Top