
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...
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...
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...
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...
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...
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...
Excel Video 366 Using Arrays to Average and to Count Errors
Excel Video 366 has more tricks with IF, ISERROR, and arrays. Today we’ll use ISERROR to look for errors...
Excel Video 367 Using Arrays to Exclude Values
In the past couple of Excel Videos we’ve found and replaced errors in our data. In Excel Video 367,...
Excel Video 368 Using Arrays with ABS
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 Using Arrays with TRUNC and Using Arrays to Sort
Excel Video 369 introduces the TRUNC function which drops everything after the decimal. TRUNC may not be...
Excel Video 370 Using Arrays to see if Data is Sorted
Excel Video 370 has an array formula that tells you if your list isn’t sorted. The trick is to know that...