by Nate Moore | May 29, 2013 | Arrays
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...
by Nate Moore | May 27, 2013 | Arrays
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...
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,...
