Hello everyone,
It was necessary to create an automatic sampling program in Excel, which has 5 columns on the first sheet that contain the following:
Sheet 1:
Column A: follows RAND() under this idea “=IF(B2>1;RAND())”.
Columns B to E have the data that are to be filtered randomly.
Sheet 2:
Brings up separately the first X data based on the sample calculation.
-
However, after the data is Copy / Pasted the user needs to filter from smallest to biggest in order to randomize the data. Then, the sampling method picks up the first X rows depending on sample size.
Having that in mind, some creative souls filter and then re-copy paste the data in a manner where the first X rows that are to be sampled are convenient to their purposes. Henceforth, they are not really randomizing rather pick the data up the necessary sampling point, since if the sample size is 40 then the first 40 lines are pasted based on their convenience.
My questions are the following:
1. Is it possible that every time data is being copy pasted in columns B to E the filter takes place automatically, and so column A is protected and nothing is necessary to be done by the user? This should also resolve the Copy / Paste issue, since it will always randomize after data is Copy / Pasted.
2. Or maybe it is possible that the data picked based on the sample size are always randomized and picked based on the population data?
Any suggestions are appreciated, thank you in advance!
It was necessary to create an automatic sampling program in Excel, which has 5 columns on the first sheet that contain the following:
Sheet 1:
Column A: follows RAND() under this idea “=IF(B2>1;RAND())”.
Columns B to E have the data that are to be filtered randomly.
Sheet 2:
Brings up separately the first X data based on the sample calculation.
-
However, after the data is Copy / Pasted the user needs to filter from smallest to biggest in order to randomize the data. Then, the sampling method picks up the first X rows depending on sample size.
Having that in mind, some creative souls filter and then re-copy paste the data in a manner where the first X rows that are to be sampled are convenient to their purposes. Henceforth, they are not really randomizing rather pick the data up the necessary sampling point, since if the sample size is 40 then the first 40 lines are pasted based on their convenience.
My questions are the following:
1. Is it possible that every time data is being copy pasted in columns B to E the filter takes place automatically, and so column A is protected and nothing is necessary to be done by the user? This should also resolve the Copy / Paste issue, since it will always randomize after data is Copy / Pasted.
2. Or maybe it is possible that the data picked based on the sample size are always randomized and picked based on the population data?
Any suggestions are appreciated, thank you in advance!
