How to insert & use Functions in Excel Functions help you perform a variety of mathematical operations, lookup values, calculate date and time, and a lot more.

There's a lot going on in these formulaic conditional rules in Microsoft Excel that highlight the smallest and largest values within a period of years.

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...