Forum Discussion
Random Contractor Selection List
Hi, I would like to set up an automated random contractor list for tender purpose - is this possible? For example, I have Contractor 1 - Contractor 10, I would like to choose 2 contractors for each ...
Or you can use a formula like this:
="Contractor " & TAKE(UNIQUE(RANDARRAY(10,, 1, 10, TRUE)), 2)Press F9 to randomly find the two different contractors.
Hope this helps.
IlirU