peterLEE0223
New Member
- Joined
- Feb 8, 2023
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
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!
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!