Arrays Part 2 Playlist

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

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

We’ll write a little more complicated formula in Excel Video 361. It might help to review Excel Videos 355...

Excel Video 362 takes our SMALL functionality to the next level by adding two more functions to the mix. If...

Instead of looking for the next future appointment, Excel Video 363 looks for the most recent past...

Excel Video 364 uses LARGE to find the last referral and OFFSET and MATCH to get the details about that...

Excel Video 365 has a clever way to sum a range of data even if the data has errors in it. You may have...

Excel Video 366 has more tricks with IF, ISERROR, and arrays. Today we’ll use ISERROR to look for errors...

In the past couple of Excel Videos we’ve found and replaced errors in our data. In Excel Video 367,...

No, Excel Video 368 isn’t a fitness videos and arrays won’t help you with your abs. ABS is an Excel...

Excel Video 369 introduces the TRUNC function which drops everything after the decimal. TRUNC may not be...

Excel Video 370 has an array formula that tells you if your list isn’t sorted. The trick is to know that...

I have one more array trick in Excel Video 371 before we move on to a new topic. Today we’ll use a COUNTIF...