Pick a Random Value From a List in Excel
To pick a random winner, question or name, use =INDEX(B3:B8,RANDBETWEEN(1,ROWS(B3:B8))). It works for a list of any length and gives a new pick each time you press F9. Any versionINDEX + RANDBETWEEN Several, no repeatsExcel 365: TAKE + SORTBY + RANDARRAY New pickPress F9 Method 1: INDEX and RANDBETWEEN =INDEX(B3:B8,RANDBETWEEN(1,ROWS(B3:B8)))Copy RANDBETWEEN picks a position from … Read more