I need to create a macro or function that will pull a random sample from
column B, but only when the criterion in column A is met. For example:
Column A Column B
A 123
A 456
A 789
B 234

I need to pull a random sample of the values in column b, but need the
ability to select the column A value. I was hoping for a button or formula
that i could move from sheet to sheet since we get a system generated list
each week.