Of course, typing a set of values or cell addresses into a function (which is what the syntax appears to suggest) isn't exactly the smartest or most efficient way to use them. Unfortunately you can't use any of these functions to find the smallest text value in a range. They have the same syntax, although you'll find that they tend to give the same result. There are a couple of related functions, MINA() and MAXA() which also consider logical values (e.g. Note that they both ignore anything that isn't a number. MIN() and MAX() function syntaxĮssentially, you feed either function a set of values, and the function calculates the minimum or maximum number, depending on which function you are using. It also introduces SMALL() and LARGE(), functions which duplicate what MIN and MAX do, plus more besides. They are simple functions that go by the names of MIN() and MAX(). In the Ribbon, go to Formulas > Defined Names > Use in Formula, then select the name you require.Excel offers a couple of handy functions that you can use to calculate the smallest and largest values in a range of cells.Press ENTER for Excel to automatically complete the formula with a closing parenthesis.Īn alternative (and simpler!) way to paste a range name into a formula is to directly select the name from the Use in Formula list.In the Ribbon, go to Formulas > Defined Names > Use in Formula > Paste Names… Then select the name required and click OK.First, type the beginning of the formula.You can also paste range names into formulas.

You cannot edit individual cells in a dynamic array or delete the values in the cells underneath your formula (for example the values in C3 and C4 in the example below): The cells, together, form part of an individual range name.

The range name will be inserted as a Dynamic Array. Press the ENTER key on the keyboard or click the check mark in the formula bar.Select the name you want to paste, then click OK.In the Ribbon, select Formulas > Defined Names > Use in Formula > Paste Names….First, select the cell where you wish the range name to be pasted.If you have a workbook that contains a lot of named ranges, you can use those range names in alternative locations or formulas in your Excel file. This tutorial will demonstrate how to paste range names in Excel.

How to find a range in excel