Random 5 Winners Tool Using Excel and ExGrid [FREE DOWNLOAD 2022]

Опубликовано: 12 Октябрь 2024
на канале: ExcelVbaIsFun

1,057

📊 Free Workbooks: https://www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

Today we've got a fun little project that helped me pick five random winners for a contest I threw out there in our Excel Ninjas Facebook Group (https://www.excelvbaisfun.com/ninja). Out of my top seven images, users voted on their favorite and in this video we create a ‘Random Winner’ selection tool using Excel and the new ExGrid control.

We took all the names from this entire Facebook feed (all of the reactions and all of the votes) and went ahead and threw them into an excel file using ExGrid.

Although this is a little bit advanced for our series on using ExGrid in Excel, we couldn’t help but share this neat little exercise with our Excel community.

We're exploring ExGrid topics such as how to change the SortType (Numerical, Dates, DateTime, String, etc) as well as a secret trick to sorting by Icon images!

This gives added control over being able to sort, filter, group and add image/icon fields. In our case, we use a little Star icon to show which people won a free course from ExcelVbaIsFun.com!

If you want to download a free demo of ExGrid and follow along (or to purchase ExGrid), please check out the link below. It’s recommended to install the grid before opening the Free Excel Workbook, because you’ll get an error if you don’t have ExGrid installed.

Get ExGrid here: https://www.excelvbaisfun.com/GridHelp

Download file here: / 1950756351762469

What is ExGrid? ExGrid is a grid control that allows you to edit, sort, filter, group, calculate, pivot data in a whole new way! Completely customize every single facet of your end-user’s experience and open up a whole new world of possibilities to what you can do in a protected Userform environment while upgrading to a modern look and feel. It’s also extremely fast at processing your data. Check it out!

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/

00:00 Intro
00:53 Quick Tour
01:18 Code Review: Loading the Grid
01:44 Adding Columns
02:37 Adding names
03:09 Sorting by String vs Numeric
03:43 Group by 'Vote' field
04:03 Getting Random Results
05:00 Loading Icons in column 3 Preview
05:17 How do load Images on ExGrid
05:35 Intro to Encoded BASE64 Images (image from string of text)
07:08 Stepping through Randomizer code
10:12 What if we run into a duplicate?!
10:49 BONUS: How to sort images/icons..
11:19 Different SortTypes
11:52 Using CellData in addition to CellValue
12:31 Making Winner column sort by CellData
13:14 Sorting 'Vote' column as numbers
13:55 Use correct SortType
14:20 Final Results (Selecting 5 winners!)
15:00 Don't forget to Subscribe, Like, Comment THANK YOU!