From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

COMBIN COMBINA

COMBIN COMBINA

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

COMBIN COMBINA

“

- [Narrator] Here's something that's pretty sophisticated to understand and I'm not going to go too deep into it. I'm just wanting to show you more of Excel. What I'm going to show you is in a fairly robust section of functions. Let's look. Formulas and more functions, statistical. Okay, there's average, average ifs, beta distribution, count A, covariance, max ifs, median, percentile. A lot of stuff here. All right, so let's look at this challenge. We got five flavors here in column B. Going from banana ginger, down to marshmallow tangerine. Hmm. Now don't tune out on me. Start thinking about cupcakes and whatnot. We're talking about Excel here, all right? Now, our little popup, we have two options that people can take. A sampler box of three and all three must be different. So, you can't get a sampler box that's all cotton candy habanero. No, no. The other option is a box of any 8. So, you can get 8 banana…

Contents