| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
survey data collection & analysis
"Kevin GPO" wrote
Thanks for your reply. Very useful. I got a problem. if entered survey 1, 2, 3, 4, 5 (all 5 surveys), then when I combine the surveys, is there any way to extract the email address uniquely? eg. it will only take that email address as appearing once, instead 5 times? By your rules, are multiple entries allowed/disallowed in the first place ? If it's disallowed, simply check & disqualify the winner(s) and re-draw. And to check on the 2 winners' statuses, you could use DataFilterAutofilter and filter on the email col (no need to check all qualifiers/entries, just the 2 winners) Anyway, one way to extract a "uniques" list is to use Advanced Filter Assume the email address data is all in col A Type a col label in A1 (if required) Select col A Click Data Filter Advanced Filter [Click OK to the Excel prompt to use the first row as labels] In the Advanced Filter dialog box: ---------------------------------------- Check "Copy to another location" Ensure that the selected range correctly appears in the "List range:" box Put for "Copy to:" : B1 (say) Check "Unique records only" Click OK The unique list of items in col A will be extracted in col B -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Collated Survey Analysis Finding Average | Excel Worksheet Functions | |||
| Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
| Data analysis data from a survey | Excel Discussion (Misc queries) | |||
Threaded Mode
