by Nate Moore | May 22, 2013 | Arrays
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...
by Nate Moore | May 20, 2013 | Arrays
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...
by Nate Moore | May 15, 2013 | Arrays
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,...
by Nate Moore | May 13, 2013 | Arrays
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....
by Nate Moore | May 8, 2013 | Arrays
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...
by Nate Moore | May 6, 2013 | Arrays
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...
