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 ...
Hi
One option with Excel 365/Web (you did not mention the version you use/run). With [Contractor ID]s from 1 to 10 in A2:A1 and their Names in B2:B11:
in D2 above:
=XLOOKUP( TAKE( UNIQUE( RANDARRAY(10,,1,10,TRUE) ), 2 ), A2:A11, B2:B11 )