Select Page

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, we’ll find and exclude zeros. Instead of using ISERROR like we have in the past couple of Excel Videos, today we’ll use , which is Excel-speak for not equal to. We’ll...

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