Last week I posted an art supply giveaway, and now I’m announcing the winner. And the winner is, according to random.org . . . .
and entry 206 is
I’ve already e-mailed the winner. But if that person didn’t get my e-mail for some reason, please contact me with your name & mailing address.
Thanks everyone for playing! I’ll be giving away more things in the future, so please subscribe to my blog and/or my newsletter so you’ll know when that happens.
As an FYI, I had asked everyone to only enter once, but had a surprising number of people enter 2 and even 3 times. But don’t worry–I went through and deleted the duplicate entries so that everyone had a fair chance. I’ll have to figure out an easier way to automatically deal with this for next time because it took some time to manually go through and do it. If anyone knows of a way to use a form that only allows 1 entry per person, please let me know. I used google docs for this one. There might be a way to do it with google docs that I’m just not aware of.
Sorry if this shows up twice.
Do you put the entries into a spreadsheet?
Neefer: Yes, google docs automatically puts it into a spreadsheet. I found an example of how to filter it so only the person’s most recent entry shows up (if they submit multiple entries), but didn’t understand how to do it:
http://tinyurl.com/3mt7tkc
What is this “goole docs” of which you speak?
Once you get the spreadsheet, what program are you using to read it? Excel? OpenOffice? Something else?
It’s all done online–so I’m reading it within google docs (http://www.docs.google.com). The link I gave above in my last comment is an example of what you see, and it’s what I found for how to filter it.
Maybe you should delete ALL entries for those who enter more than once. That might discourage people from entering multiple times.
Google docs is neat-o!
So, here’s what to do.
Open your file in google docs as a spreadsheet.
Highlight (choose) all of your data.
Click on the funnel shaped symbol. It’s the last one on the right for me.
You will get little blue triangles in the top row’s cells.
Click on the triangle in the column that you want to sort. I think yours was e-mail.
Choose A-Z.
@Neefer: Yes, that’s how I found the multiple entries. But according to that article I found and link I posted in my first comment, there’s a way to do it so the duplicates don’t even show. But I can’t figure that out.
@Janet: While that would discourage people from entering more than once, I would hate to do that. I think some people had some computer or internet glitches, and that’s why they had duplicate entries. Some people didn’t get their whole e-mail address in and tried again. So I’d hate to disqualify someone that had something like that happen.
After I posted the last comment, I went to bed. While I was falling asleep, I realized that I hadn’t finished.
I’m thinking it would take a bit of programming to catch e-mails that are not quite the same, like neferduir@yahoo.co and neferduir@yahoo.com
However, if the contents of the cells are identical, I can help. I’m assuming column D is empty.
In cell D2, put the following code:
=if(c2=c1, 1, 0)
which means if the email address in C2 is exactly the same as the e-mail address in C1, put a 1 here.
Hightlight cell D2. On the lower right hand corner of the highlighted cell is a little box. Click & hold on the box and drag it down column D until you get to the last entry in column C.
All the addresses that are duplicates will have a 1 to the right.
Make sure that the “filter” covers column D. You may have to click filter off and back on.
Show only the zeros.
copy column C
Show all entries in Column D.
Paste into Column E.
Column E will have your list with no duplicates.