Forum Discussion
KingPush000
Jan 19, 2025Copper Contributor
Selecting random data from spread sheet
I'm trying to randomly select 30 housing prices from a specific region on my data spread sheet... what formula do I use so it picks a random 30 without having the #spill error show so each data piece gets their own respective number. I did the randarray function and it'd giving me a head ache.
Can you give us an idea of what the data look like?