Random Select based on 2 or 3 columns

[DEllis]

Hi Everyone, I have a spreadsheet that has a unique identifier in column A, in Column J I have a date and in column R I have a function.

What I want to do is pull 25% of the last quarter based on Column, and spread the pull based on function so I don't have all the same function each quarter.

Is this even possible?

Thank you as always
DEllis

 

[DEllis]

Hi Everyone, I have a spreadsheet that has a unique identifier in column A, in column J is a date and in column R is a function.

What I need is to pull 25% of the last quarter based on Column J and spread the pull based on column r so I don't pull all from the same function each quarter.

Is this even possible?