I stopped using the Excel filter button to find high and low values. These 2 functions do it better

Excel’s filter button is useful, but I’ve realized I was relying on it for the wrong job. When all I wanted was the highest or lowest number that matched a certain condition, filtering meant hiding rows, sorting data, and then resetting everything afterward. But two functions I recently stumbled across have given me a much cleaner way to get those answers.

Find high and low values without filtering your data

Let Excel find the answer for you