Select Page

Excel Video 359 Using SMALL to Find the Third Next Available Appointment

Excel Video 359 has a way you might start using arrays in your practice. If you can download your open appointment slots into Excel, the SMALL function can help you find the next available appointment, the third next available appointment, and more. SMALL is a...

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,...

Excel Video 356 SUM with OR Criteria in an Array

Excel Video 356 offers one more complicated formula, but once that formula works, it’s very powerful. We’re going to do an OR criteria in an array today. If you missed Excel Video 355, please take a minute to watch it first. Today’s video will make a lot more sense....

Excel Video 355 SUM and Multiple IFs in an Array

I hope you don’t have to spend a ton of time rewinding Excel Video 355. The array formula to sum multiple criteria at once is complicated. The SUMIFS formula in Excel Video 185 is a much easier approach to summing a range of data that meets multiple criteria. The...

Excel Video 354 SUM and IF in an Array

Excel Video 354 has a practical example of an array formula. We’ll write a formula that loops through a range of cells to sum the collections if the year equals 2009. The array formula is made up of two parts that might be best understood from the inside out. The...