openoffice excel random selector from set list equation

While we’re at it, you’ll also learn to use functions to make a random pick from the list.įor our example to be used throughout this guide, we will randomize the following list of names that are arranged in an alphabetical order: This tutorial will teach you how to randomize a list in Excel using functions alone and also with the Excel Sort & Filter feature. Or maybe you’re just randomly aiming to be an Excel nerd. You might want to rearrange dates or scramble a list of names or products.

just to prevent tipping the balance that comes from good old alphabetical sorting. You may want to randomize a list of names of students, employees, contestants, etc. Although we do have functions to help us along with that and that’s what we will be looking up in a bit. Excel is quite proficient with sorting lists alphabetical order, chronological order, ascending and descending order but it’s yet to come up with straight-up randomization (nearly oxymoron-ish).

That is true for life and Excel and we are here for the Excel side of matters. Organizing is good but sometimes a measure of randomness makes things better.

Openoffice excel random selector from set list equation