The MATCH Function
The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range .
1804, 2019
Category Archives: Functions
1804, 2019
The INDEX Function
The INDEX function returns a value or the reference to a value from within a table or range.
1804, 2019
The CHOOSE Function
The CHOOSE function returns a value from an array of values, that corresponds to a specific position in that array.
1804, 2019
The SUMIFS Function
The SUMIFS function adds the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Mathematical functions of Excel.
1804, 2019
The COUNTIFS Function
The COUNTIFS function counts the number of times certain criterias are met. Even though its logical elements, it is part of the Statistical functions of Excel.
1804, 2019
The AVERAGEIFS Function
The AVERAGEIFS function returns the arithmetic mean (average) of all the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Statistical functions of Excel.
0504, 2019
The TRANSPOSE Function
The TRANSPOSE function transposes (rotates) a range of cells.
We can transpose our data by using the relevant Paste Special option also but it will create duplicate data.
0404, 2019
The MAX function
The MAX functions returns the largest number in a set of values.
If you need to get the second or third or n-th largest number in a set of values then you should use the LARGE function.
0404, 2019
The MIN function
The MIN functions returns the smallest number in a set of values.
If you need to get the second or third or n-th smallest number in a set of values then you should use the SMALL function.
0404, 2019
The SMALL function
In statistics the MIN function is not enough. The need to calculate, for example, the third smallest value of a range of cells, is very common.
This is what the SMALL function calculates. It returns the n-th smallest value from an array of numeric values.
