php editor Baicao will share with you today how to make a simple excel lottery applet. Record the information of the people participating in the lottery through the excel table, then use the random function to select the winner in excel, and finally display the results to everyone. The production process is simple and easy to understand, making the lottery more interesting. Come and try it now!
1. First, we open the Excel software and open the table we prepared. The table must contain our names.
2. Then we merge the cells on the right, fill in black who is lucky tonight, and merge the cells below and fill in red, as shown in the figure below Show.
3. Then we enter the randbetween function in the red area, set the first line to 2, and the last line to 7, as shown in the figure below.
4. Then we enter the index function in front, and the references in the first two rows of Index are columns.
5. Finally, after we complete the quotation, add another bracket, and then click OK. We can see that the system automatically fills in a person's name.
6. Then we press the Enter key to start, and the candidate’s name will appear randomly, as shown in the figure below
After reading the course shared by the editor, have you learned how to create an Excel lottery applet? The editor also shows the steps very carefully. If you can't get the desired effect at one time, just do it a few more times and you will definitely complete the desired operation successfully. The editor will continue to bring you useful knowledge, remember to follow us!
The above is the detailed content of How to make an excel lottery applet. For more information, please follow other related articles on the PHP Chinese website!
How to convert number to text in Excel - 4 quick waysMay 15, 2025 am 10:10 AMThis tutorial shows how to convert numbers to text in Excel 2016, 2013, and 2010. Learn how to do this using Excel's TEXT function and use numbers to strings to specify the format. Learn how to change the format of numbers to text using the Format Cell… and Text to Column options. If you use an Excel spreadsheet to store long or short numbers, you may want to convert them to text one day. There may be different reasons to change the number stored as a number to text. Here is why you might need to have Excel treat the entered number as text instead of numbers: Search by part rather than the whole number. For example, you might want to find all numbers containing 50, such as 501
How to make a dependent (cascading) drop-down list in ExcelMay 15, 2025 am 09:48 AMWe recently delved into the basics of Excel Data Validation, exploring how to set up a straightforward drop-down list using a comma-separated list, cell range, or named range.In today's session, we'll delve deeper into this functionality, focusing on
How to create drop down list in Excel: dynamic, editable, searchableMay 15, 2025 am 09:47 AMThis tutorial shows simple steps to create a drop-down list in Excel: Create from cell ranges, named ranges, Excel tables, other worksheets. You will also learn how to make Excel drop-down menus dynamic, editable, and searchable. Microsoft Excel is good at organizing and analyzing complex data. One of its most useful features is the ability to create drop-down menus that allow users to select items from predefined lists. The drop-down menu allows for faster, more accurate and more consistent data entry. This article will show you several different ways to create drop-down menus in Excel. - Excel drop-down list - How to create dropdown list in Excel - From the scope - From the naming range
Convert PDF to Excel manually or using online convertersMay 15, 2025 am 09:40 AMThe PDF format, known for its ability to display documents independently of the user's software, hardware, or operating system, has become the standard for electronic file sharing.When requesting information, it's common to receive a well-formatted P
How to convert Excel files to PDFMay 15, 2025 am 09:37 AMThis short tutorial describes 4 possible ways to convert Excel files to PDF - using Excel's Save As feature, Adobe software, online Excel to PDF converter, and desktop tools. Converting an Excel worksheet to a PDF is usually necessary if you want other users to be able to view your data but can't edit it. You may also want to convert Excel spreadsheets to PDF format for use in media toolkits, presentations, and reports, or create a file that all users can open and read even if they don't have Microsoft Excel installed, such as on a tablet or phone. Today, PDF is undoubtedly one of the most popular file formats. According to Google
How to use SUMIF function in Excel with formula examplesMay 13, 2025 am 10:53 AMThis tutorial explains the Excel SUMIF function in plain English. The main focus is on real-life formula examples with all kinds of criteria including text, numbers, dates, wildcards, blanks and non-blanks. Microsoft Excel has a handful o
IF function in Excel: formula examples for text, numbers, dates, blanksMay 13, 2025 am 10:50 AMIn this article, you will learn how to build an Excel IF statement for different types of values as well as how to create multiple IF statements. IF is one of the most popular and useful functions in Excel. Generally, you use an IF statem
How to sum a column in Excel - 5 easy waysMay 13, 2025 am 09:53 AMThis tutorial shows how to sum a column in Excel 2010 - 2016. Try out 5 different ways to total columns: find the sum of the selected cells on the Status bar, use AutoSum in Excel to sum all or only filtered cells, employ the SUM function
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Dreamweaver Mac version
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
WebStorm Mac version
Useful JavaScript development tools
Atom editor mac version download
The most popular open source editor
DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
