Excel Random Seleciton under couple of conditions

[peterLEE0223]

I am making peer evalution group and rator should be selected randomly among same department collegues.

I have a table of records (named "Table1") and I want VBA to randomly return 5 individual number (each number should be on the different cell and table header is called "rator1~rator5") from the table where

- all rators (1~5) must belong in same department(dep) with individual ==> within same department member
- all rators (1~5) must be selcected without duplicates

Any help would be greatly appreciated!