Random sampling based on specific criteria from another column

[symaxf]

Hello again!

I have a workbook that contains data only in Sheet 1
Row 1 contains Headers - The number of rows can vary from 2 - 20,000+
Columns = A thru N
Col A = Unique ID (Number)
Col N = Names (Contains Duplicates)
Cols B thru L contains mixed data

I am using the following macro to copy a RANDOM 10% of every row in Sheet 1 into Sheet 2 which works great. The problem I have is I need to ensure that at least ONE of every Name listed in Col N is included in the 10% copied to Sheet 2.

Please Login or Register  to view this content.

Any help would be much appreciated!

[symaxf]

Hmmm, I see a lot of views but no replies to this thread so I am restating my request for clarity:

I have a list of unique file numbers in Column A and a Name associated with it in Col N.
There are 5000 rows of Data. I would like to pull a random sampling of the file numbers based on the following criteria:
- 10% of the total File Numbers in Col A
- At least 1 file for each Name (There are 100 unique Names)
- The final 10% can contain duplicate Names but needs to contain at least one File Number for each Name

So for this sample, Sheet 2 should contain 500 rows of data containing 100 unique Names.

Can this be done?

Thx!

[symaxf]

Did I stump the experts or do I need to add a sample file???