Select Page

Excel Video 365 Using Arrays to Sum Ranges with Errors

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

Excel Video 364 Using LARGE to Find the Last Referral Part 2

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

Excel Video 363 Using LARGE to Find the Last Referral

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

Excel Video 362 Using Arrays with SMALL, Part 3

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

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