Selecting random cells based on criteria
Hi I have a sheet that contains a few thousand entries.
In column "D" I have a value assigned to each entry (A, - W)
What I want to do is select a random set of entries for each of the criteria in column "D" and return a list of cell values that are in column "A"
However the number of cells I want to return changes for each criteria
So for example If cell in column "D" contains an "A" I want to return the value of the corresponding cell in Column "A".
So far so good?
The next twist is that there is a variable number of entries for each criteria (A, B, C, etc... ,W)
So if there are a total of 56 entries with an "A" in column "D" I want to specify the number of random entries I want returned for example I only want 9 of the 56.
If that hasn't totally confused everyone, any suggestions on how to do this would be welcome.
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago