by Nate Moore | Jun 12, 2013 | Arrays
Excel Video 365 has a clever way to sum a range of data even if the data has errors in it. You may have noticed that if your data has an error message in it, Excel formulas like SUM show the error instead of the total. My first choice is always to fix the error, but...
by Nate Moore | Jun 10, 2013 | Arrays
Excel Video 364 uses LARGE to find the last referral and OFFSET and MATCH to get the details about that referral. If you’ve watched the last several Excel Videos, using LARGE to calculate the last referral date will be pretty straight-forward. This time we’ll take the...
by Nate Moore | Jun 5, 2013 | Arrays
Instead of looking for the next future appointment, Excel Video 363 looks for the most recent past appointment from a referring physician. We’ll switch from SMALL to LARGE today to look for the largest past appointment, which turns out to be the most recent...
by Nate Moore | Jun 3, 2013 | Arrays
Excel Video 362 takes our SMALL functionality to the next level by adding two more functions to the mix. If VLOOKUP is new to you, it might help to watch the VLOOKUP playlist starting with Excel Video 61. If you aren’t familiar with WEEKDAY, watch Excel Video 165....
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...
