Extracting multiple records from a Data set

I have a data I want to analyze by extracting at random, 4% of the unique record in column 1 and is either Gold or Silver as indicated in the second column.

I will be glad to have your assistance.

Data Source
Iretioluwa OlawuyiRTM AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
Can you explain/specify in what form is the output desired?
Iretioluwa OlawuyiRTM AnalystAuthor Commented:
Thank you for your response sir,

The table below is a summary of the other file I shared, I wanted to extract a list from the record such that for each item on the first column as shown below, I have an extraction equal to the no of rows as indicated in the column with the 4% header. I could use a filter and go through one by one, but I believe there's a better way to go about it.

PS Territory      No       4%
94C5A1AA      281      12
94C5A1AB      344      14
94C5A1AC      224      9
94C5A1AD      211      9
94C5A1AE      315      13
94C5B2AA      281      12
94C5B2AB      411      17
94C5B2AC      341      14
.
.
.
Grand Total      79904
Saqib Husain, SyedEngineerCommented:
Take a look at this file
Data-Extract.xlsx
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Iretioluwa OlawuyiRTM AnalystAuthor Commented:
Many thanks for the attempt sir, I appreciate it.
However, what you did is the summary and what I really need is the data just like this extract I did manually...

94C5A1AA      Silver
94C5A1AA      Gold
94C5A1AA      Silver
94C5A1AA      Gold
94C5A1AA      Silver
94C5A1AA      Gold
94C5A1AA      Silver
94C5A1AA      Gold
94C5A1AA      Silver
94C5A1AA      Silver
94C5A1AA      Silver
94C5A1AA      Gold
94C5A1AB      Gold
94C5A1AB      Silver
94C5A1AB      Silver
94C5A1AB      Gold
94C5A1AB      Silver
94C5A1AB      Gold
94C5A1AB      Gold
94C5A1AB      Silver
94C5A1AB      Silver
94C5A1AB      Gold
94C5A1AB      Silver
94C5A1AB      Silver
94C5A1AB      Gold
94C5A1AB      Silver

This is what you did sir

94C5A1AA      281      12
94C5A1AB      344      14

I can't seem to continue manually, else I'll spend the whole day on it.
If you've worked with queries on MS Access, I can exploit that as well, but I haven't gotten a query that gives me what I wanted.
Saqib Husain, SyedEngineerCommented:
Does this file do what you want?

You will have to have macros enabled and click on the given button
Data-Extract.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Iretioluwa OlawuyiRTM AnalystAuthor Commented:
I will like to thank you very much for your support on this challenge Sir,
I know I can't thank you enough but I pray that God will bless you. Amen.
I was able to read through the vba code and will go ahead to use it and append the remaining variables to column G.
Many Thanks!!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.