Select Page

Happy New Year everybody! Welcome back to another year of Excel Videos at We’ll start the year with a different approach to advanced filters in a table in Excel Video 393. Instead of putting complex formulas and syntax above the table, we’ll add several columns to the table to calculate which appointments are most likely to not show up. Once you’re familiar with the IF function, adding these additional columns and criteria is no big deal. Now that we have the criteria, we just use the SUM function to add up the new columns and determine which patients are most likely to miss their appointment.
Stay tuned. We’ll simplify these formulas one step further next time. Thanks for watching.