Archive for SMALL function
SMALL function with multiple cell ranges
Today I learned how to sort numbers from multiple cell ranges thanks to Sam Miller. It is surprisingly simple and easy. […]
The array formula in cell C11 gets 3 values in one fetch, the INDEX function allows you to do that […]
How to ignore zeros using the SMALL function
The formula in cell D3 is an array formula, it will extract the k-th smallest value ignoring zeros.
SMALL function – multiple criteria
The array formula in D10 extracts numbers sorted from small to large from column D if Region is equal to […]
The array formula in column E, shown in above picture sorts text values from column B. The Length columns prove […]
SMALL function with duplicates
The formulas in column E, shown in the picture above, extracts the k-th smallest value from B3:B9 ignoring the duplicate numbers. […]
INDEX MATCH – multiple results
The array formula in cell E6 extracts values from column C when the corresponding value in column B matches the […]
The SMALL function lets you extract a number in a cell range based on how small it is compared to the other numbers in the group.
Match two criteria and return multiple records
Question: I have a table of 3 columns (Security name, date, price) and I have to find the price of […]
5 easy ways to VLOOKUP and return multiple values
This post explains how to lookup a value and return multiple values. No array formula required.
Extract largest values from two columns
Question: How do I extract the five largest values from two or more columns? Answer: Formula in A12: =INDEX(tbl, SMALL(IF(LARGE(tbl,ROW(A1))=tbl, […]
Table of Contents Sort a column using array formula Two columns sorting by the second column Sort alphanumeric values I […]
Table of Contents Find closest value Find closest values Find closest values and return adjacent values Find closest value with […]
