View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
KevinGPO KevinGPO is offline
external usenet poster
 
Posts: 16
Default HELP: survey data collection & analysis

I need urgent help and am new to Excel. I've got 5 excel surveys which is
similar to:

http://www.surveymonkey.com/ExportEx...rtExamples.zip

I am using SurveyMonkey.com to do 5 surveys (which are all exactly the
same), however it's separated for 5 societies. Results can be
downloaded/exported as CSV files (as you can see in the ExportExamples.zip
file). So there are 5 of those ExportExamples.zip (above), one for each
society am surveying. How can I combine the 5 Condensed.csv files so it's
one big file?

I need the Condensed in one big file. Then I want to make Excel, or any
program, to randomly chose 2 winners/users from the combined-list. (It's for
a draw of 2 winners). Is this possible in Excel, or some other program? How
can I do this?

Many thanks
Kev