课程: Excel Weekly Challenge

免费学习该课程！

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

Count the L names

Count the L names - Microsoft Excel教程

课程: Excel Weekly Challenge

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

Count the L names

“

- Let's have some fun. We have the two lists of names, and we want to know how many names either start or end with L. We want to count Leo, count Rachel. Nestor? No, there's no L anywhere there. Saul? Yes. Nell? Yes. Lowell? All right. So now you should be asking me, "Oz, what about Lowell? He starts and ends with L. Should that be counted as 2 or 1?" No. In this case, we want to count it as 1 name. Now I don't care what method you use. You can write VBA code, write a big monster formula, write several small formulas, sort, use power query, whatever you want to do. But do not eyeball this and go Lowell. Leo, 1. Rachel, 2. Morgan, Denise, Nell, 3. Gil, 4. No, don't do that. No. That's error prone and your eyes can trick you. Alright, pause the video. Count how many names start or end with L. (upbeat music) You got a number? Okay, I'm going to slide this out of the way, and I'm going to give…

内容