Sorry I may not be explaining this very well.

You are right about the column mixup in your file, sorry the data is an extract of my full sheet which has several more columns but these shown are the key ones.

Your example, while it extracts all the values that correspond to a certain letter as requested then lists them in the same order in which they appear in the original data. What I am trying to get is a random selection of all records that are classed as "A, B, C, etc." by entering the number of random selections I want for each letter;

Letter "A" may return 56 values but I want 7 random values from that 56. Currently your formula seems to return values 1 through 7 and then hides the rest.

What I had hoped for was of the 56 records identified the 7 random values would be something like;

Value 1 = Record 3
Value 2 = Record 44
Value 3 = Record 9
.
.
.
Value 7 = Record 19