I am so frustrated with Excel 2003 Data Analysis Tool. I hope you can help. I have a file with 11,432 rows and 6 columns; first, mid and last name, userid, 7-9 numberic number and status. All can be text. I just want to be able to pull out 200 random samples based upon the 7-9 numeric number. Everytime I run the random sampling analysis and output to a new worksheet same workbook, I get the error message – sampling Input range contains non-numeric data. What am I doing wrong? I tried filling the same number of cells as the 7-9 number with a 1 and then did a copy and paste special multiply to convert from text to number and that worked on the column but I still get the same message. ????? Any help would be greatly appreciated!! Thanks
