A1 thru A5 has a list of fruits (Apple, Orange, Watermelon, Banana, Pineapple). B1-C5 has a listing of sub-types of each these fruits. I would like an output in E1 thru E7 which will give me a random selection of 7 these subtypes in the B1-C5 array, and the random selection should contain at least one subtype of each fruit type from column A, but can contain more than 1 subtype. Again, it's random, so there might be 2 apple types, 2 banana types, and 1 each of Orange, Watermelon, and Pineapple. I do want to make sure that the output in E1 to E7 does not repeat values.
Any ideas?
Any ideas?