Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT- Random Sample per range of data
I am trying to create a function (?) that will allow me to get a specific
number of randomly selected cells out of a range. I know this is available, but I can't seem to get it to do the following: BACKGROUND- I have a spreadsheet that has employee names for the column titles, and training module names for each row. The connecting cells indicate the date which these training modules were completed [ex- Joe Shmoe (column title) was training on Beancounting (row title) on 7/7/77 (coordinating cell data).] PROBLEM- I need to randomly select 315 cells out of a range of employees/training modules (for example, range B2-AF247). I know this can be accomplished through the analysis tool, but I can't seem to get it to simply HIGHLIGHT THE RANDOMLY SELECTED CELLS within the actual spreadsheet. Instead, it seems to only pull the actual data out of the cells and throw it somewhere else, which prevents me from having any reference as to the employee and training module. SOLUTION- ??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I random sample from a set until every sample is selected? | Excel Discussion (Misc queries) | |||
Random Sample with multiple data points | Excel Worksheet Functions | |||
can i do a random sample with non-numeric data? | Excel Discussion (Misc queries) | |||
Selecting a Random Sample of 15 from a Large data set | Excel Worksheet Functions | |||
Is it possible to do a random sample of non-numeric data in Excel? | Excel Discussion (Misc queries) |