课程: Excel Weekly Challenge

免费学习该课程！

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

Find the missing numbers

Find the missing numbers - Microsoft Excel教程

课程: Excel Weekly Challenge

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

Find the missing numbers

“

- [Instructor] Let's have some fun and find the missing numbers. We've got this grid that's supposed to have the numbers 1 through 250 in random order. First, find out are there 250? Are there 249? How many are missing and then list the missing numbers. Got that, pause video, do that detective work and then come on back. (upbeat music) - [Instructor] All right, let's get into this. How many numbers do we have? We're supposed to have 250. I'm going to highlight here, look at this. We have 240 numbers here. Now let's verify that. I'm going to use equals count A. That's the function that counts non empty cells and right here and enter. Yep, we have 240, which means we are missing 10 numbers. Let's find those 10 equals two call. All right, I'm going to put this into a column and then I'm going to show you something really slick and easy. Boom. Alright, there are the numbers. Okay, now I'm on a control shift down arrow…

内容