I need to use the data fron an excel file but I need also to pick-up randomnly.
I need to use the data fron an excel file but I need also to pick-up randomnly.
If you do not need to have a non uniform distribution in your selection.
one method is to in the column next to the data enter
=rand()
Select the two columns and sort by the rand column. Your data wiill now be
in a random order. If you just select the data in series you will have a non
replace random selection.
If you nned a new set, just sort by the rand column again.
If you need a replace type selection.
at the top of the column next to the data enter 0 then one cell down enter
=1/data count.
Increment by the 1/data count to the bottom of the data.
then set up a series of random numbers betwween 0 and 1, and use these as
your selection criteria in a Vlookup
"How to get the data randomnly?" wrote:
> I need to use the data fron an excel file but I need also to pick-up randomnly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks