"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 ***