Shulou(Shulou.com)06/03 Report--

When it comes to the lucky draw, everyone thinks of the recent "pay Bao Kam Lei letter fool", but what I am talking about with you today is not this, but: will you use Excel to make the lottery function? Maybe you don't know that Excel has so many divine skills, but there are many you don't know. The production of Excel raffle is actually very simple. Follow me, you can get new skills every day!

Come with me to see how to make this Excel raffle function:

Let's take a look at the moving picture.

1. The A1:A23 cell shown in the picture is the name of all the employees. We will randomly pick out any employee name in the C4 cell. Enter the formula in the C4 cell: "= INDEX (A rect RANDBETWEEN (1mem23)").

2. Lottery cursor production: select column A, click start-"conditional format"-"New Rule".

In the pop-up dialog box, select "use the formula to determine the cells to format"-- enter "= A1=$C$4" in the "format" text box-- click the "format" button.

The font color is set to Red.

Fill color is set to "× ×"-click the "OK" button.

3. Press and hold the F9 key to realize the random lottery function!

4. Complete dynamic drawing operation.

Formula hint:

INDEX: used to return numeric values or references to numeric values in a table or region.

RANDBETWEEND: returns a random number between the specified numbers.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.