Calculate the smallest or largest number in a range
网页Calculate the smallest or largest number in a range. Use Autosum and Max or Min to calculate the largest or smallest value in a range. For example, you can use it to find out who has the the smallest error rate in a production run at a …
RANK function - Microsoft Support
网页A number specifying how to rank number. If order is 0 (zero) or omitted, Microsoft Excel ranks number as if ref were a list sorted in descending order. If order is any nonzero value, Microsoft Excel ranks number as if ref were a list sorted in ascending order.
RANK.EQ function - Microsoft Support
网页Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. If you were to sort the list, the rank of the number would be its position.
MINIFS function - Microsoft Support
网页The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
MIN function - Microsoft Support
网页This article describes the formula syntax and usage of the MIN function in Microsoft Excel. Description. Returns the smallest number in a set of values. Syntax. MIN (number1, [number2], ...) The MIN function syntax has the following arguments: Number1, number2, ...
SORT function - Microsoft Support
网页The SORT function sorts the contents of a range or array. In this example, we're sorting by Region, Sales Rep, and Product individually with =SORT (A2:A17), copied across cells F2, H2, and J2. Syntax. SORT returns a sorted array of the elements in an array.
Guidelines and examples of array formulas - Microsoft Support
网页Sum only numbers that meet certain conditions, such as the lowest values in a range, or numbers that fall between an upper and lower boundary. Sum every Nth value in a range of values. The following examples show you how to …
Use the table_array argument in a lookup function
网页The table_array argument is always the second argument in a VLOOKUP or HLOOKUP function (the first is the value you're trying to find), and the functions won't work without it. Your first argument, the value you want to find, can be a specific value such as "41" or "smith," or it be a cell reference such as F2.
Sort data in a range or table - Microsoft Support
网页Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons.
Use Goal Seek to find the result you want by adjusting an input …
网页On the Home tab, in the Number group, click Percentage. Click Increase Decimal or Decrease Decimal to set the number of decimal places. If you know the result you want from a formula but aren't sure which input is needed to …
Filter by using advanced criteria - Microsoft Support
网页Filter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.