SORT The SORT function can help if you need to arrange data in a range in ascending or descending order to make it easier to find specific data in your Excel sheet.

In a nutshell, these functions return either the minimum or maximum value within a range where criteria returns true. When a function has multiple criteria arguments, all must return true.

Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.