Make this RANDBETWEEN Work With Columns Instead of Rows

[jworkman7]

I've got about 100 rows of data, with 100 columns across. I want to use the below formula to give me one random output from the columns in each row. The formula gives me a #REF if I plug in columns instead of rows:

=INDEX($C:$C,RANDBETWEEN(1,COUNTA($C:$C)),1)

 

[dave3009]

Hi

Probably something to do with placement of row/column references, try:

=INDEX($2:$2,1, RANDBETWEEN(1,COUNTA($2:$2)))

 

[jworkman7]

Thanks Dave... so simple, I didn't even see the solution.