Select Page

Excel Video 361 Using Arrays with SMALL, Part 2

We’ll write a little more complicated formula in Excel Video 361. It might help to review Excel Videos 355 and 356 since today we’ll look for the third next available appointment for a new patient in the South location. To find an appointment that’s both new and...

Excel Video 360 Using Arrays with SMALL, Part 1

Excel Video 360 uses arrays with the SMALL function to find the next available appointments. The first example uses an IF statement as part of the array component of the SMALL function to find the third next available new patient appointment. The IF statement limits...

Excel Video 358 ROUND in an Array

Excel Video 358 has another way arrays might make your life easier. I have five clinical measures that I’ve summed and then rounded the result. If I want to round the measures first and then sum the result, you guessed it, arrays can help. We’ve done several examples...

Excel Video 357 LEN in an Array

As promised, there’s an easier array example in Excel Video 357 today. In today’s example we’ll assume that someone’s been counting something such as no shows, patients who arrived more than 15 minutes late for their appointment, or patients needing an xray. To count,...