How to use Excel to Randomly Pick a Contest Winner

Use Excel to Randomly Pick a Contest Winner

I wanted to share with you all how to use Excel to randomly pick a contest winner. Apparently there are several ways to do this, as I discovered when I did a Google search for it. For those of you that have done this before, what did you use?

I used good ol’ fashioned Excel. I’m on Excel 70% of my day anyway for work so I didn’t want to learn anything new. And, there’s something really comfortable about that spreadsheet view for me. Makes me naturally trust it, for some weirdo reason.

So, I just created a list of all the eligible entries in my spreadsheet. And used the following formula…

Use Excel to Randomly Pick a Contest Winner
Use Excel to Randomly Pick a Contest Winner / Image Source: Pepper V.

For a copy/paste version of it you can use…

=INDEX(B6:B13, RANDBETWEEN(1,COUNTA(B6:B13)),1)

The only thing you need to customize, is where you see the “B6:B13” – it appears twice in the formula and those are the fields where MY list is in the spreadsheet. You just change those fields to match where YOUR list is. And that’s it. You can now use Excel to randomly pick a contest winner.

Super simple, right? If you give it a try, let me know how my steps worked out for you… If I need to include more info or details, etc.

Have a great day!

We have a winner!

Hi everyone!

I did my drawing for my wine giveaway tonight and we have a winner!

We only had 8 eligible entries, which meant the odds were super-good this time! Nobody entered on my FB so that was a bust. But between my blog and my IG, we had 8 eligible entries.

I used the randomizer formula on excel…

… and samosaswmimosas is the winner. Congratulations!

Image Source: me

Don’t feel bad if you didn’t win this time. I expect to be invited to more of these wine parties, and I expect to do more of these giveaways to justify my attendance. So stay tuned! πŸ₯‚πŸ·πŸΎ

My First Giveaway! Wine!

Hi everyone! Trying out this whole giveaway thing and I hope it works out. Do any of you want to win some wine?!

I have a friend that sells Scout & Cellar wine. She’s having one of those selling parties this Friday and I am going. I’m going to eat her delicious food and chat with her other friends and I’m going to buy a couple bottles of wine from her in support.

But… I’m not really a wine drinker. I actually don’t like wines, champaigns, or beers. Lol I don’t even know how to spell champaign, it looks wrong to me here. When I do drink, I prefer the mixed drinks with either vodka or rum.

Anyhow, I’m still going to support my friend and buy a couple bottles from her. But one of you all will receive it instead bc I don’t want it.

I’ll randomly draw the winner Wednesday night. I’ll contact you and you’ll tell me what kind of wine you like – white, red, pinot, etc. You’ll have to give me your shipping address too (so make sure you’re comfortable giving an internet stranger your shipping address). And I’ll go to my friend’s party Friday night, place the order, I’ll pay for it, and I’ll put YOUR shipping address on the order.

You do have to be eligible to have this wine shipped to you. You must be:

1) At least 21 years old. The shipment delivery will require to see your ID as proof of being at least 21. They won’t leave it at your door. No P.O. Boxes either. If you won’t be home for delivery, you can use the tracking number (I’ll give it to you) to hold the shipment at your nearest FedEx office for you to pick up at your convenience.

2) In the U.S. only – I’m sorry my international friends! And the following States cannot be shipped to, so please don’t enter if you live in one of these States: Arkansas, Delaware, Kentucky, Mississippi, Rhode Island, Utah.

Ok, I think that’s about it. Geez, it looks like alot of rules, I’m sorry about that. I thought this would be simple.

To enter the drawing, you have to be following either my blog, my FB page, or my IG. And just leave me a comment on any of those platforms that you want to enter and that you are eligible.

So that’s all the scoop I have. I’ll draw the winner Wednesday night. Good luck everyone! 🍷🍾πŸ₯‚

Here’s a photo of what I ordered last time I went to one of her selling parties. I plan on bringing these as gifts to any holiday events I go to…