• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Random 10% Data Sample in each category actioned by assignee for Quality check

Smriti

New Member
I need to find the 10% of data of each Assignee in different FunctionalTracks he has worked for the Audit and Quality Check.The data may go in thousands 5000+. Could you please help I have mentioned the output also.

Regards
Simi
 

Attachments

Hui

Excel Ninja
Staff member
Simi

Firstly, Welcome to the Chandoo.org Forums

Can you please clarify,

Are you after 10 random entries or 10 random entries that match eg: IT Tier 1 and System? etc where you specify IT Tier 1 and System/RAM ?
 

Smriti

New Member
Hi Hui,

I need to pick 10% of System and 10% of RAM of all the tracks they have worked.Please let me know if any clarifications needed.
Regards
Simi
 

Hui

Excel Ninja
Staff member
See if the attached solves your problem

I have added a helper column that adds a random number if the Assignee matches a Chosen value
Then I simply pick the lowest 10% of the values
press F9 and you will get different values each time as the random numbers change
I have added a CF to highlight the selected data in the source data so you can check it
 

Attachments

Top