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 appointment from a referring physician. The LARGE formula works just like SMALL does, so if you missed the last couple of Excel Videos, it’s worth going back and watching from Excel Video 359 forward. Today’s Excel Video will make a lot more sense if you have that background.
I hope you can see how powerful these array formulas can be. Stay tuned. We’ll add a little more complexity by adding OFFSET and MATCH next time.