![]() Which version will you use? Do you have Excel 365 now? Or are you still using an older version of Excel? Name List ChooserALL – For all Excel versions – INDEX/MATCH functions, limit of 10 names.Chooser365 – For Excel 365 – Spill functions in cells D3 and E3 list numbers and names. ![]() There are 2 “Chooser” sheets in the workbook: The workbook uses formulas to do the choosing – there aren’t any macros to worry about. There’s a new sample file on my Contextures site, and you can use it to randomly choose items from a list. As long as you have a list of the names, or ticket numbers, or anything else, Excel can do a random draw for you. Do you ever need to choose random names from a list in Excel? Maybe your charity is picking winners for a raffle, or your blog is doing a giveaway, or you need “volunteers” for a special project at work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |