Select Random Sample Values and Rows using Excel

[@ccat0014]

thanks a lot. I was frustrating on how to choose random data for my assignment.

[@LocoCioco]

thank you for sharing your knowledge in such a simple and elegant way

[@AnthonySmoak]

Thanks for the great feedback!

[@nsanerydah]

Man that is amazing stuff! Great job!

[@AnthonySmoak]

Thank you!!

[@taradavis2120]

Is there a way to do this to keep the array dynamic? My list of data will have more or less values added to it so I can't have a specified array like in the formula you use but I still need to randomly select values from my specified data :INDEX(Calculations!$F$53:$F58,RANDBETWEEN(1, ROWS(Calculations!$F$53:$F58)),1)

[@TracyBondBird]

This is really helpful!

[@keys4words]

Thanks!

[@AnthonySmoak]

Glad you found the video useful!

[@WaterBuffaloTM]

Hey brother thanks so much! We would love to have you on our podcast!

[@joeyjarina]

Is it possible that instead of the specific random number, it will show a specific data corresponds to that random number. For example, I want 3 sample calls per agent to listen for my audit from a raw data. In that data, there are master IDs which I can use to pull up the call. In a day, there’s a lot and different master ID per call and chat. Now, instead of a random number, I want the master ID to show on my file.

[@AnthonySmoak]

Try to use a VLOOKUP with RANDBETWEEN as your first argument. The assumption is that your master ID is a number that can be generated with RANDBETWEEN and is associated with the data values you need to lookup.

[@andreasconstantinou9587]

wish you described how you can avoid duplicates.

[@AnthonySmoak]

Delete them.

[@antonrinaldo971]

Lifesaver!

[@KrishanSingh-gz9op]

But what if there are two or more columns of names?

[@AnthonySmoak]

Either stack all values in 1 column or improvise to first select a random column and then a random number in that column.

[@dendon3384]

stop saying 'right'

[@AnthonySmoak]

Right away