How to find the minimum and maximum values within a specified set of years in Excel Your email has been sent Image: iStock/Rawpixel Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...

More complex default value setting requires Excel Macro scripts to be written, for example, setting a different default value depending on the value of other columns in the spreadsheet.

SEE: Excel power user guide (TechRepublic ... result of a special SUBTOTAL() function that returns the maximum value in the filtered set. In other words, the lookup value for the VLOOKUP ...