ExcelBanter - View Single Post - Select a random value from a column of values

Thread: Select a random value from a column of values

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming,microsoft.public.excel.misc

JE McGimpsey JE McGimpsey is offline

JE McGimpsey is offline

external usenet poster

Posts: 4,624

Default

Select a random value from a column of values

Or, if you don't want to rely on an Analysis Toolpak function:

=INDEX(A:A,RAND()*20+1)

In article ,
"Frank Kabel" wrote:

another way:
=INDEX(A1:A20,RANDBETWEEN(1,20))

Reply With Quote

Reply With Quote