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)
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.
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.
thanks a lot. I was frustrating on how to choose random data for my assignment.
thank you for sharing your knowledge in such a simple and elegant way
Thanks for the great feedback!
Man that is amazing stuff! Great job!
Thank you!!
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)
Thanks!
Glad you found the video useful!
This is really helpful!
Hey brother thanks so much! We would love to have you on our podcast!
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.
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.
wish you described how you can avoid duplicates.
Delete them.
Lifesaver!
But what if there are two or more columns of names?
Either stack all values in 1 column or improvise to first select a random column and then a random number in that column.
stop saying 'right'
Right away