课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Randomize three ways

Randomize three ways - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

Randomize three ways

“

- [Instructor] Randomizing data is a pretty important and handy thing to be able to do in Excel for a lot of reasons. And let's say in this situation, we want to randomly pick five people to go on a weekend on this beautiful boat, okay? The goal is to give some thought to three ways that you can randomize this list so that then you can fish out the top five, but we're not going to do that part. We want to start thinking about how can we randomize this, right? Pause the video. You know the drill, work that out, then come back. I'll be here. (upbeat music) Okay, let's get to sorting. I'm going to slide this out of the way so we can work. Way number one, I'm going to do equals RANDARRAY, double click. How many rows of data? I'm going to do counta, open parentheses, close parentheses, comma, I want one column, comma, I want my min to be, let's have some fun with this, negative 18, comma, the maximum, 400, and enter…

内容