Forum Discussion

AnthonyMcIntyre's avatar
AnthonyMcIntyre
Qrew Member
3 years ago

Lists and Random Functionality

Hi everyone, I am new to QB so these questions could have simple solutions so I figured I would post them. I am currently uploading 100K+ in entries from excel and want to select a random 1000 from the data set. Is there a way to do that? I looked into the report formulas and pipelines and nothing stood out, but doesn't mean it's not there. 2nd - If not, I know how to randomize it based off sorting the data a particular way, but didn't know if I am able to limit the output of the table to only 1000 rows? Either would work, but a random function would be more idea.

Thank you
Anthony

------------------------------
Anthony McIntyre
------------------------------
No RepliesBe the first to reply