by Nate Moore | Jun 24, 2013 | Arrays
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...
by Nate Moore | Jun 17, 2013 | Arrays
Excel Video 366 has more tricks with IF, ISERROR, and arrays. Today we’ll use ISERROR to look for errors and then use the IF statement to decide what to do with the errors. Note that if we replace errors with two double quotes “”, Excel will not count the error cell...
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...
