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.
