Forum Discussion

phuiyee's avatar
phuiyee
Occasional Reader
Jan 16, 2026

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 tender/quotation request randomly. Currently, it is done manually which is time consuming and could not ensure impartiality in selection - if I can setup the contractor rota to generate random selection, it would be wonderful. Please can anyone advise and help with the correct way to setup my excel sheet? Many thanks

Formulas and Functions

2 Replies

  • IlirU's avatar
    IlirU
    Brass Contributor
    Jan 17, 2026

    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

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jan 17, 2026

    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 )

     

Resources