Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula numbers and text Trying to pull a random sampling
How do I change text to numbers then back to text?
My file has 4 worksheets. Sheet 1 - Copy from the "copy sheet" - process type (text) check amt (numbers) check No.( numbers) Sheet 2 - Paste to "random sample listing" worksheet (formula set as =concatenate (g2," ,"e2," ",a2) Sheet 3 - Universe of Sample -formula =random sample listing'!h2 Sheet 4 - "Random selection worksheet - When using the Tools , Data Analysis, Sampling, I receive the error "Sampling - Input range contains non-numeric data" Is it because on sheet 1 there is a mixture of text and numbers, how can I change the text to numbers to run the data analysis, sampling then after the sampling is complete use a formula to return the text back to the text data to identify the type of process type? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random Sampling | Excel Discussion (Misc queries) | |||
How to sort al list in random order for sampling? | Excel Discussion (Misc queries) | |||
Random Sampling rows | Excel Discussion (Misc queries) | |||
Random Sampling | Excel Discussion (Misc queries) | |||
how to use excel to do random sampling | Excel Discussion (Misc queries) |