旧金山优胜美地_从Excel的名称列表中选择优胜者

最新推荐文章于 2024-09-16 09:47:29 发布

culiao2169

最新推荐文章于 2024-09-16 09:47:29 发布

阅读量231

点赞数

文章标签： excel poi java django 大数据

原文链接：https://contexturesblog.com/archives/2009/06/29/pick-a-winner-from-a-list-of-names-in-excel/

版权

旧金山优胜美地

Here's how I ran a small contest, and what I did to pick a winner from a list of names in Excel.

这是我进行小型竞赛的方式，以及从Excel的名称列表中选择赢家的方法。

Facebook专页 (Facebook Page)

Remember the old days, when only the kids belonged to Facebook, and they used it to plan parties, and post embarrassing photos? Well, now almost everybody has signed up, and the kids have probably moved somewhere else, and they're hoping that we don't discover where.

还记得过去的时候，只有孩子属于Facebook，他们用它来筹划聚会并张贴令人尴尬的照片吗？好吧，现在几乎每个人都签了名，孩子们可能搬到了其他地方，他们希望我们不知道在哪里。

I have a personal account, and also created a page for Contextures. I hadn't done much with that page (okay – nothing), and it had a couple of fans. (Thank you, to those first two fans.)

我有一个个人帐户，还为Contextures创建了一个页面。我在该页面上没有做很多事情(好–没有)，并且有很多粉丝。 (谢谢您，前两个粉丝。)

Over the weekend, I read that pages with 25+ fans could register for a customized URL. That sounded like a fun challenge, so I created my first ever book giveaway event (you need to log in to Facebook to see that page).

在周末，我读到有25个以上粉丝的页面可以注册自定义URL。这听起来像是一个有趣的挑战，所以我创建了我的第一个图书赠品活动 (您需要登录Facebook才能看到该页面)。

The rules were simple -- become a fan by Sunday evening, for a chance to win a signed copy of one of my pivot table books (US and Canada mailing addresses only).

规则很简单-在周日晚上成为粉丝，就有机会赢得我的数据透视表书(仅美国和加拿大的邮寄地址)的签名副本。

选择优胜者 (Selecting the winner)

Since my books are about Excel, it seemed logical that Excel should pick the winning fan. As I explained in the giveaway announcement:

由于我的书是关于Excel的，因此Excel应该选择获胜者似乎是合乎逻辑的。正如我在赠品公告中解释的那样：

All fan names will be entered in an Excel sheet, and the Rand function will be used to select the winner's name.

所有风扇名称都将输入到Excel工作表中，而Rand函数将用于选择获胜者的名称。

Here's how I picked the winner:

这是我挑选获胜者的方法：

In cells A1:B1, enter the headings, Name and Number, and format those cells as Bold
在单元格A1：B1中，输入标题，名称和编号，并将这些单元格的格式设置为粗体
List all the fan names in column A, under the column heading "Name".
在列“名称”下的A列中列出所有风扇名称。
In cell B2, type a RAND formula: =RAND()
在单元格B2中，键入一个RAND公式： = RAND()

Pick a Winner From a List of Names in Excel

Copy the formula down to the last row of data.
将公式向下复制到数据的最后一行。
To change the cells to values, select all the cells with formulas, and copy and paste as values.
要将单元格更改为值，请选择所有具有公式的单元格，然后将其复制并粘贴为值。
Select a single cell in column B, and click the Sort Smallest to Largest button on the Ribbon's Data tab.
在B列中选择一个单元格，然后单击功能区“数据”选项卡上的“按最小到最大排序”按钮。
The name at the top is the lucky winner of a pivot table book!
顶部的名称是数据透视表书的幸运儿！

Excelapalooza！ (Excelapalooza!)

Well, the giveaway was fun, so I'll do it again in a couple of weeks.

好吧，赠品很有趣，所以我会在几周后再做一次。

Or maybe we could organize an Excelapalooza, and everybody with an Excel site or blog could collect names and contribute a prize. Imagine the awesomeness! ______________

或者，也许我们可以组织一个Excelapalooza，每个拥有Excel网站或博客的人都可以收集姓名并贡献奖品。想象一下真棒！ ______________