Excel Random Seleciton under couple of conditions

peterLEE0223

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

1675911829647.png



Any help would be greatly appreciated!
 

Attachments

  • CAPPNG.PNG
    CAPPNG.PNG
    43.5 KB · Views: 6

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top