random pick from a range (with replacement); count > 1 spills a column · a deepcalc original · no excel equivalent · no sheets equivalent

signature

RANDOMCHOICE(choices, [count])

returns: any · volatile — recomputes on every evaluation

argument	required
choices	required
count	optional

usage

• =RANDOMCHOICE(A1:A10)
• =RANDOMCHOICE(A1:A10, 3)

related

• FROMBYTES converts byte array to integer
• GENERATEID generates unique ID with prefix and random suffix
• HASH hex digest of text: SHA256 (default, FIPS 180-4) or MD5 (RFC 1321)
• IMAGE shows an image from a url — the browser loads it, the engine does not fetch
• ISIN checks if value is in a range or comma-separated list
• RANDOMINT.UNIQUE generates unique random integers in range